Originally posted by karthik Guru:
If my database goes down and then comes up after sometime, is my database connection pool and datasource still valid?. If not, is it possible at all to initiate a reinitialization of the pool and the datasource programmatically? do i need to read up weblogic JMX?
I cannot say positively, but it makes sense that the connection pool would recover just fine. For example, WebLogic already recycles (as in throw away and create anew) connections after a specified period of time. As well you can tell WL to
test connections each time they are handed out from the pool. If you're using Oracle, give it the "dual" table and WL will select count(*) from it each time.
However, it's totally my assumption that WL is smart enough to create connections to replace broken ones (otherwise why test them?). Give it a try.
