Force New Connection Pool

2010-02-03 Thread Dan Denton
Hello all. I'd like to find a way to force my tomcat instances to get new 
connection pools, without stopping and starting the instances and kicking out 
all of my connected users.

I'm using Oracle RAC with a failover service, and should one node fail, our 
tomcat instances don't reconnect automatically. Doing a full stop/start can be 
time consuming, so I was wondering if it were possible to make them reconnect 
without a full restart.

I'm running tomcat 5.5.12 on RHEL4 with JDK1.5.

Thanks in advance...


Re: Force New Connection Pool

2010-02-03 Thread Filip Hanik - Dev Lists

On 02/03/2010 08:31 AM, Dan Denton wrote:

Hello all. I'd like to find a way to force my tomcat instances to get new 
connection pools, without stopping and starting the instances and kicking out 
all of my connected users.

I'm using Oracle RAC with a failover service, and should one node fail, our 
tomcat instances don't reconnect automatically. Doing a full stop/start can be 
time consuming, so I was wondering if it were possible to make them reconnect 
without a full restart.

I'm running tomcat 5.5.12 on RHEL4 with JDK1.5.

Thanks in advance...

   

If you're already paying a bunch of money for RAC, then use the RAC features

Resource
  name=jdbc/test
  auth=Container
  type=oracle.jdbc.pool.OracleDataSource
  factory=oracle.jdbc.pool.OracleDataSourceFactory
  connectionCachingEnabled=true
  connectionCacheName=ConnectionCache
  fastConnectionFailoverEnabled=true
  ONSConfiguration=nodes=oraclehost1:1521,oraclehost2:1521
  

there are a bunch of other attributes that are Oracle specific, and this 
will get you what you want


-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org