Re: Database connection pooling errors in Tomcat 5.5.17

2006-10-17 Thread Saurabh Nanda
Thanks. I got it working: 1. Removed the oracle driver from WEB-INF/lib and put it in common/lib 2. Used the format of the URL given below: jdbc:oracle:thin:@address:port:schema -- but it's rather strange -- is this documented anywhere? When I was using the "normal" (non DBCP) method to connect t

Re: Database connection pooling errors in Tomcat 5.5.17

2006-10-17 Thread Saurabh Nanda
ojdbc14.jar should be in $TOMCAT_HOME/common/lib to be available to both the container and your webapp. Nopes: o Put it in $CATALINA_HOME/common/lib alone -- same error o put it in webapps/appname/WEB-INf/lib and $CATALINE_HOME/common/lib, both -- same error! Does oracle drier support DBCP? N

Re: Database connection pooling errors in Tomcat 5.5.17

2006-10-17 Thread Saurabh Nanda
This is the complete stacktrace of the error if it helps. The ojdbc14.jar file is in the WEB-INF/classes directory. SEVERE: Servlet.service() for servlet test threw exception java.lang.NullPointerException at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConnection.java

Database connection pooling errors in Tomcat 5.5.17

2006-10-17 Thread Saurabh Nanda
Hi, I'm trying to configure a pooled database connection in Tomcat 5.5.17 but getting a strange error which looks like this: java.lang.NullPointerException org.apache.tomcat.dbcp.dbcp.DelegatingConnection.close(DelegatingConnection.java:151) org.apache.tomcat.dbcp.dbcp.PoolableConnection.reall