aspose file tools*
The moose likes Websphere and the fly likes Bob Janson question: WebSphere and DB connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Bob Janson question: WebSphere and DB connections" Watch "Bob Janson question: WebSphere and DB connections" New topic
Author

Bob Janson question: WebSphere and DB connections

Seth Dustin
Greenhorn

Joined: Sep 15, 2010
Posts: 7
All my customers are always wanting to have Websphere manage the database connection instead of letting our application do it. Well, a lot of times, that connection goes away and then the customer asks me to troubleshoot the reason the web app isn't working. I tell them to talk to their websphere expert to figure out why the DB connection isn't being maintained.

First- Why are these folks always wanting WebSphere to manage the connection?
Second- How can they figure out why the DB connection keeps getting dropped?

thanks!!!
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30530
    
150

I'd want WebSPhere to manage the connections too. The container is good at that.

Dropped connections are using a connection pooling setting that is incorrect. For example, maybe the min # connections is too high and there are stale connections.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Bob Janson question: WebSphere and DB connections