Anybody managed to use 9i thin driver in Tomcat 5?

From: harry <spammemothers_at_yahoo.co.uk>
Date: Fri, 22 Oct 2004 16:16:12 GMT
Message-ID: <gnaed.2237$i02.270@fe1.news.blueyonder.co.uk>

using tomcat 5.0.28, oracle 9.2.1.0

having a nightmare here, upgraded from oracle 8i to 9i, downloaded & installed ojdbc14 in Tomcat's common\lib directory.

Now all I get is useful when trying to create a connection pool -

2004-10-22 17:04:22 StandardContext[/PRD]action: null java.lang.NullPointerException

   at
org.apache.commons.dbcp.DelegatingConnection.close(DelegatingConnection.java :151)

   at
org.apache.commons.dbcp.PoolableConnection.reallyClose(PoolableConnection.ja va:95)

   at
org.apache.commons.dbcp.PoolableConnectionFactory.destroyObject(PoolableConn ectionFactory.java:301)

   at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS ource.java:883)

   at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav a:851)
etc...

from my web.xml file -

<resource-ref>

 <description>Oracle Datasource example</description>
 <res-ref-name>PRDConnectionPool</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>

</resource-ref>

from my app xml file -

   <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>jdbc:oracle:thin:prd_owner_at_127.0.0.1:1521:dev91</value>
   </parameter>

Worked fine under 8.1i but now I've hit a brick wall with this one - is it possible to get these to work together?

Probably doing something really stupid, any ideas?

thanks

harry Received on Fri Oct 22 2004 - 11:16:12 CDT