tomcat JNDI DATASOURCE SQLNestedException
843838Aug 9 2005 — edited Jan 25 2007Hi,
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