Forums Register Login

connection pool

+Pie Number of slices to send: Send
I want to use connection pool in my servlet.
This is the error message i am getting-
"Error Message is:java.sql.SQLException: Cannot load JDBC driver class 'null'"
I have made necessary changes in web and server.xml..
server.xml
-------------
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbcracle:thin:myschema@127.0.0.1:1521:mysid</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
web.xml
-----------
<resource-ref>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Here is my code..
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
thanks in advance
+Pie Number of slices to send: Send
I'm not sure, but when you do the lookup with the context is it ... or without the leading slash before 'comp'?
Sorry I can't be more helpful.
I like you because you always keep good, crunchy cereal in your pantry. This tiny ad agrees:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1307 times.
Similar Threads
Is this true: JNDI equals Connection Pooling
DBCP => Cannot create JDBC driver of class '' for connect URL 'null'
Databse Connectivity Error
JNDI in webapps
Tomcat Database Connection Pooling Error
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 02:44:07.