I am getting the error as DataSource invalid: "java.sql.SQLException: No suitable driver".
Instead, If I use the following code it is working properly. <% Connection connection = null; InitialContext ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("jdbc/gms"); connection=ds.getConnection(); Statement stmt = connection.createStatement(); String sqlquery="My Query"; ResultSet rs = stmt.executeQuery(sqlquery); %>
I am not sure why JSTL SQL Query is not working. Please help.