Re: OracleConnectionPoolDataSource

2007-07-23 Thread Julio J. Suárez Salinero
it. Note: I'm not Zdenek. I'm Julio. Regards. -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 10:27 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource -BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Julio,

Re: OracleConnectionPoolDataSource

2007-07-23 Thread Julio J. Suárez Salinero
Zdeněk Vráblík escribió: Hi, 4. I use OracleConnectionPoolDataSource because with javax.sql.DataSource it doesn't close correctly close connections from pool and server got to hang up. Have you got any exception? It throwed "Closed Statement", "Exhausted Resultset" and "NullPointerException

Re: OracleConnectionPoolDataSource

2007-07-20 Thread Julio J. Suárez Salinero
I'll try to answer all your questions and tell you what state is the page now. 1. I get the same results with "oracle.jdbc.pool.OracleConnectionPoolDataSource", "oracle.jdbc.OracleDriver" and "oracle.jdbc.driver.OracleDriver". Currently I'm using "oracle.jdbc.OracleDriver". 2. I am importin

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Julio J. Suárez Salinero
he full oracle.jdbc.driver.OracleDriver it had said the latter was deprecated. However, that may not be the crux of your problem but you could try it. Thanks for the advice. I'll try it. I have not experimented with the getPooledConnection method so I can't say. -Original Mes

Re: OracleConnectionPoolDataSource

2007-07-19 Thread Julio J. Suárez Salinero
I have get it to work from a context resource. I've had to specify a factory attribute. Currently context.xml is this: User and password doesn't work in context.xml. I have used a getPooledConnection overload: Context ctx = (Context) initCtx.lookup("java:/comp/env"); OracleConnectionPoolD

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
Caldarale, Charles R escribió: From: "Julio J. Suárez Salinero" [mailto:[EMAIL PROTECTED] Subject: OracleConnectionPoolDataSource I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. Don't suppose

Re: OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
Zdeněk Vráblík escribió: Hi, There is error in driverClassName. Try use this: driverClassName="oracle.jdbc.driver.OracleDriver" Thanks, but I already have tested that with the same results. Zdenek On 7/18/07, "Julio J. Suárez Salinero" <[EMAIL PROTECTED]> wrote

OracleConnectionPoolDataSource

2007-07-18 Thread Julio J. Suárez Salinero
I'm Trying to connect a JSP tomcat-based application to Oracle using OracleConnectionPoolDataSource and related classes. I have used javax.sql.DataSource an it did work fine. I have made changes I need for using that classes and when I get the DataSource it throws exception "javax.naming.Naming