Hi,
I created a JDBC resource called "jdbc/gms" under SUN JSAS admin. I am trying SQL query using JSTL tag in a JSP page as follows.
<sql:query var="learning" dataSource="jdbc/gms">
Query
</sql:query>
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.
I created a JDBC resource called "jdbc/gms" under SUN JSAS admin. I am trying SQL query using JSTL tag in a JSP page as follows.
<sql:query var="learning" dataSource="jdbc/gms">
Query
</sql:query>
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.