I'm fairly sure that there are people using it but you may have to wait until it's not 
the weekend for you get an answer.

-----Original Message-----
From: spammemothers [mailto:[EMAIL PROTECTED]
Sent: 24 October 2004 12:13
To: 'Tomcat Users List'
Subject: RE: Does Oracle 9i thin jdbc driver work in Tomcat 5?


Please is anyone using Oracle 9 with tomcat 5? - I've really hit a brick
wall here & still have no idea if it's my fault or it just doesn't work!

I just want to setup a connection pool of Oracle 9 thin JDBC connections!

Thanks

harry

-----Original Message-----
From: spammemothers [mailto:[EMAIL PROTECTED] On Behalf Of Adrian
Harrison
Sent: 23 October 2004 17:28
To: [EMAIL PROTECTED]
Subject: Does Oracle 9i thin jdbc driver work in Tomcat 5?


using tomcat 5.0.28, oracle 9.2.1.0 on windows 2000 (sp4)

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

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

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:[EMAIL PROTECTED]: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?

many thanks

harry





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Any opinions expressed in this E-mail may be those of the individual and not 
necessarily the company. This E-mail and any files transmitted with it are 
confidential and solely for the use of the intended recipient. If you are not the 
intended recipient or the person responsible for delivering to the intended recipient, 
be advised that you have received this E-mail in error and that any use or copying is 
strictly prohibited. If you have received this E-mail in error please notify the 
beCogent postmaster at [EMAIL PROTECTED]
Unless expressly stated, opinions in this email are those of the individual sender and 
not beCogent Ltd. You must take full responsibility for virus checking this email and 
any attachments.
Please note that the content of this email or any of its attachments may contain data 
that falls within the scope of the Data Protection Acts and that you must ensure that 
any handling or processing of such data by you is fully compliant with the terms and 
provisions of the Data Protection Act 1984 and 1998.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to