Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tomcat JDBC connection - Cannot create resource instance

843854Jan 3 2005 — edited Mar 5 2007
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2007
Added on Jan 3 2005
11 comments
2,250 views