• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DataSource invalid

mahesh rao
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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">

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");
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic