Greetings,
I'm trying to configure my oracle datasource to work with fail-overs of my database. I mean, if database makes a restart for instance, I pretend to somehow validate the connections of my datasource.
With DBCP (Apache/commons connection pool), I have configuration that I could say what would be my query validation (select 1 from dual). Even with database restarts, I would get always valid connections.
With JBOSS, I only saw these parameters (see jboss-ds_1_0.dtd):
<min-pool-size>5</min-pool-size>
<max-pool-size>50</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
There is none about query validation!!!
So, when I simulate a restart of my database (oracle) I got exceptions like this:
org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.)
How can I fix this problem?
thanks,
Pedro Salazar.