aspose file tools*
The moose likes Websphere and the fly likes cleaning up connections in websphere Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "cleaning up connections in websphere" Watch "cleaning up connections in websphere" New topic
Author

cleaning up connections in websphere

Fred Abbot
Ranch Hand

Joined: Jun 01, 2000
Posts: 300
hi
I am running a an application on websphere using connection pools to connect to an oracle database
and everything is great
except if the database goes down websphere is unaware that it went down and tries to connect using the old connections which are no longer in use the only way around it is to restart websphere there by getting new connections does any one know how to ensure that websphere removes old connections and makes new ones when a database goes down
thank you
Abe
Rahul Mahindrakar
Ranch Hand

Joined: Jul 28, 2000
Posts: 1859
Yes you are right Fred

if the database goes down websphere is unaware that it went down and tries to connect using the old connections which are no longer in use the only way around it is to restart websphere there by getting new connections does any one know how to ensure that websphere removes old connections and makes new ones when a database goes down

I wrote a simple servlet that connects to a Database [oracle to be precise] and then i stopped the oracle server. The servlet does not work. Then i restarted the oracle database. The servlet still does not work until the appserver is restarted.
I am going through documentation lets see.
Workaround --- Anybody???
Fred Abbot
Ranch Hand

Joined: Jun 01, 2000
Posts: 300
there is a workaround provided by websphere in chapter 10 of the websphere handbook
it says to cacth a staleConnectionException which is in the package
com.ibm.ejs.cm.portability
the problem is i am using Visual Age for Java(IBM)
and it wont allow me to catch that particular exception
go figure
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: cleaning up connections in websphere