• Post Reply Bookmark Topic Watch Topic
  • New Topic

is JMX the way to go for this  RSS feed

 
Karthik Guru
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
Before that it w'd be great if somebody c'd tell me if programmatic reinitialization is possible in the first place and then if JMX is the way to go.
thanks!
 
David Harkness
Ranch Hand
Posts: 1646
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!