Restoring database connection

[snaresh]

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

[davidjencks]

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)