RE: JDBC resource with custom connection pool factory

2007-05-30 Thread Propes, Barry L
do you mean like the amount of users per a pool connection instance? I think you're stuck with configuration inside the WEB-INF level per app. -Original Message- From: Sorin Juco [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 2:41 AM To: users@tomcat.apache.org Subject: JDBC re

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Zdeněk Vráblík
HI ROOKIE, I probably didn't understand the question properly. I have configured datasource with OracleDatasourceFactory and I have expected that DataSource.getConnection return OracleConnection and when I close this connection it will return this connection to the pool instead of close this con

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Sorin Juco
Thanx for the answers. I just realized that what I want to do is more complex. I use Hibernate and pass the jdbc resource to the Hibernate configuration. Oracle has a temporary table for each session to the database in which you can store 2 varchar arguments for monitoring purposes ( in my case

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread ROOKIE
To execute custom code while getting a connection u can extend the connection factory and mention that class as the factory for ur resource, I dont think we close connections using the factory, so maybe u can write a wrapper around Connection.close() method. - Original Message From: S

Re: JDBC resource with custom connection pool factory

2007-05-30 Thread Zdeněk Vráblík
Hi, I use this Resource: There is OracleDataSourceFactory in ojdbc14.jar. Regards, Zdenek On 5/30/07, Sorin Juco <[EMAIL PROTECTED]> wrote: Hello, I want to create a JDBC resource wich represents a connection pool to an Oracle server. By default Tomcat uses DBCP to provide the connection