DataSource Problem - JSTL
Hi,
I have created a JDBC DataSource under Sun App Server 8.1 Admin with JNDI name "jdbc/gms". I have configured the web.xml as follows.
<context-param>
<param-name>javax.servlet.jsp.jstl.sql.dataSource</param-name>
<param-value>jdbc/gms</param-value>
</context-param>
<resource-ref>
<description>GMS Data Source</description>
<res-ref-name>jdbc/gms</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
and sun-web.xml ....
<resource-ref>
<res-ref-name>jdbc/gms</res-ref-name>
<jndi-name>jdbc/gms</jndi-name>
</resource-ref>
Now, I am trying the following Query in JSTL after setting datasource.
<sql:setDataSource dataSource="jdbc/gms" />
<sql:query var="classificationQry">
select classification_id, classification
from tblclassification
</sql:query>
When I run the page, I am getting following error.
javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
Please help.
