I am having problem accessing db connection via JNDI in Tomcat 5.*. I am getting error message javax.naming.NamingException: Cannot create resource instance. I have also copied all the lib jar files under common\lib.
Following is my server.xml
<ResourceParams name="jdbc/student">
<parameter><name>username</name><value>sa</value></parameter>
<parameter><name>password</name><value></value></parameter>
<parameter><name>driverClassName</name><value>org.hsqldb.jdbcDriver</value></parameter>
<parameter><name>url</name><value>jdbc:hsqldb:hsql://127.0.0.1/mydb</value></parameter>
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
</ResourceParams>
Following is my web.xml
<resource-ref>
<description>My Datasource</description>
<res-ref-name>jdbc/student</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Following is my Java code :
Context initCtx = new InitialContext();
// Look up our data source
DataSource ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/student");
Please help its killing.