how to reestablish the connection pool when database rebounc

[zhuoershi]

anybody know if jboss could automatically re-establish the JDBC connection when Database re-cycle, and does not need to restart the server?

is there any configure setting in Jboss allow checking for some table (like oracle dual table) to detect the pool status in order to refresh the connection?

i know weblogic has that kind of setting, but not sure if jboss enables.

any help?

[e-mail]

[mharnvi]

I'm also experience problems when the database (Oracle 9i) goes down and then up. It seems to me that JBoss still thinks the Connections work and ds.getConnections() returns broken ones.

I get SQLException (Socket closed) in my code.

(Jboss 3.06)

[frito]

If I remember right, I think I read something about a cache invalidaton framework (indeed, there is a cache invalidation manager mbean installed) since JBoss 3.2 .

Perhaps you should check out this if it fits your needs.

Greetings,
Frito