Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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 JNDI DATASOURCE SQLNestedException

843838Aug 9 2005 — edited Jan 25 2007
Hi,

I am using tomcat 5.5.9 and oracle 9i. I am hosting a portal which uses connection pooling.
I have decided to use the connection pooling through tomcat's JNDI naming lookup.

for this i have used the following steps --
1) made entry of <resource-ref> in webapp's web.xml
2) made relevant and corresponding entry in tomcat's ${TOMCAT_HOME}/conf/context.xml (for JNDI JDBC-datasource)

my problems are--
1) making the entry for context.xml in tomcats conf folder makes the application war dependent on web server which i dont want to make.
2) i have to put classes12.jar in tomcats ${TOMCAT_HOME}/common/lib folder and only then the application connection pooling works else the exception coming on tomcat console is -- org.apache.tomcat.dbcp.dbcp.SQLNestedException.

I dont want to put classes12.jar in web server i want the web server's JNDI lookup to pick the driver frm my webapps' internal lib folder. please help me on these very pressing and immediate issues. all the help coming from anyone in this regard is very much welcome.
thanks in advance!
Vaiv
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2007
Added on Aug 9 2005
8 comments
170 views