Harry Potter and the lost Weblogic-database connection
Hi All,
I don't know if this is the correct forum, but here goes...
I'm working with Weblogic, connecting to an Oracle database on a rather unstable network. From time to time, the connection to the database is lost, and at the moment, this means having to restart weblogic.
Is there any way to configure weblogic to automatically reconnect to a database if the connection is lost and then restoired?
Thanks in advance for your help.
you should have a connection pool setup in weblogic and if the connection is bad, you return gracefully from that method/class, then when you try again you'll acquire a fresh connection
but you absolutely SHOULD NOT have to restart the server for this
even if the db server goes down and gets rebooted you shouldn't have to restart weblogic
Thanks for the replies. I had rummage through the configuration (this is the first time I've worked with Weblogic) and found a setting; "Refresh Period", which I duly set to 1 minute. I also ticked "Test Reserved Connections" and "Test Released Connections". I rekcon that's what I needed..
Cheers folks!
