Re: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-11-05 Thread Zdeněk Vráblík
HI, I am using a bit different connection configuration to get OracleConnection: Resource name=poolname auth=Container type=oracle.jdbc.pool.OracleDataSource factory=oracle.jdbc.pool.OracleDataSourceFactory connectionCachingEnabled=true user=DB password=DB driverClassName=oracle.jdbc.OracleDriver

Re: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-10 Thread Ziggy
Hi, I had a look at the tomcat dbcp documentation and found that it is possible to retrieve the underlying connection. As described here http://commons.apache.org/dbcp/configuration.html The problem i am getting now is that i still cannot cast the class properly to get the underlying

Re: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ziggy, Ziggy wrote: The problem i am getting now is that i still cannot cast the class properly to get the underlying connection. Your best bet is to use standard JDBC API calls instead of trying to use Oracle's proprietary APIs. You may have to

Re: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-10 Thread Ziggy
Hi, I am really stuck with the tomcat connection pool as its the application server that i am using. How does the oracle connection pool work? Could you point me to some info somewhere so that i can read about it. Thanks On Fri, Oct 10, 2008 at 2:51 PM, Christopher Schultz [EMAIL PROTECTED]

dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-09 Thread Ziggy
Hi All, I am using jdbc to connect to an oracle database but having a bit of a problem. Here is some details Jdbc driver - Type 4 App server - Tomcat 5.5 Oracle Version - 10g I have placed the jdbc driver on both the following directories [code] $TOMCAT_HOME/common/lib/

RE: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-09 Thread Caldarale, Charles R
From: Ziggy [mailto:[EMAIL PROTECTED] Sent: 2008 October 09, Thursday 11:12 org.apache.tomcat.dbcp.dbcp.PoolingDataSource I have placed the jdbc driver on both the following directories [code] $TOMCAT_HOME/common/lib/ $APPLICATION_ROOT_DIR/WEB-INF/lib/ [/code] Never, never, never put the

Re: dbcp error with java.lang.ClassCastException: org.apache.tomcat.dbcp.dbcp.PoolingDataSource

2008-10-09 Thread Ziggy
Hi, I originally only had it on $TOMCAT_HOME/common/lib but it didnt work. I only put it on both locations to test it out. I have now removed the copy from $APPLICATION_ROOT_DIR/WEB-INF/lib/ and i still have the same problem described below. Thanks On Thu, Oct 9, 2008 at 5:35 PM, Caldarale,