1 Reply Latest reply on Oct 18, 2001 1:00 AM by David Jencks

    Restoring database connection

    naresh Newbie

      Hello Everybody,

      I am using JBoss 2.4 and Oracle 8i as database server. I have a question regarding database connection.

      At the JBoss startup, database server(oracle) is running and some applications accessing the database. Now if Oracle database service stops and resumes after some times.

      What will happen during the time database is down?
      Will JBoss server restore the database connection automatically??
      Is there any parameter by which i can specify that "At a particular interval look at the database connection, whether it is up or not"


      Regards
      Naresh

        • 1. Re: Restoring database connection
          David Jencks Master

          No there isn't, however if no one is trying to use jboss while oracle is down, and you know how long it will be down for, you may be able to use the idle timeout.

          Set idletimeout to maybe 1/2 oracle downtime
          IdleTimeoutEnabled = true
          GCEnabled = true
          GCIntervale also about 1/2 Oracle downtime.

          Then connections that are idle between 1/2 and 1 Oracle downtime will be discarded and replace with new ones when requests are made. (you probably want pool min size 0 also)