8 Replies Latest reply on Oct 7, 2003 9:28 AM by pedrosalazar

    restart database invalidates datasource

    pedrosalazar

      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 work around this problem?

      thanks,
      Pedro Salazar.