It's not a secret anymore!
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


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32636
    
215

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.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Bob Janson question: WebSphere and DB connections
 
It's not a secret anymore!