This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.