aspose file tools
The moose likes BEA/Weblogic and the fly likes Detailed info on pooled JDBC connections? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Reply Bookmark "Detailed info on pooled JDBC connections?" Watch "Detailed info on pooled JDBC connections?" New topic
Author

Detailed info on pooled JDBC connections?

Matt Walker
Greenhorn

Joined: Sep 24, 2001
Posts: 2
Is there a way to get detailed information on pooled JDBC connections? The information given in the weblogic console regarding connections currently in use, pool size, awaiting pool connection, etc. is quite useful although I'm looking for something a little more detailed. Specifically, I'd like to be able to get a stack trace of the object currently in control of each pooled connection and possibly information regarding what query has been passed to the database.
The reason I ask is that I'm trying to debug a problem where my "Connections currently in use" continually grows until it reaches the maximum and then it starts queueing connections and eventually brings down the server instance with "Out of Memory" errors. My initial thought was that somehow connections weren't getting returned to the pool after they had been used. I looked over the code and I don't think this is the case, or at least it's not a case of forgetting to close the statement, result set, and connection. I also don't think it's a traffic issue either as the number of current connections doesn't correspond with the execute queue throughput.
Hmmm... Any advice?
Thanks!
-- Matt
Hong Ho
Greenhorn

Joined: Sep 16, 2001
Posts: 11
Hi,
Try to start the Weblogic server
with this option if you getting memory problem.
Change the option in the start script....
java -ms256m -mx512m
bla bal bla...
...
...
weblogic.Server

This effects the server performance a lot.
Thanks
Matt Walker
Greenhorn

Joined: Sep 24, 2001
Posts: 2
Thanks Hong Ho... I've actually tweaked the heap size quite a bit already. The best that it did was to make the server meltdowns fewer and farther between, although it didn't fix the problem altogether.
 
 
subject: Detailed info on pooled JDBC connections?
 
Threads others viewed
Stale Connection
connection pooling
General JDBC Questions for new Open Source project
running out of ManagedConnections available
Connection Pooling Question
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com

cast iron skillet 49er

more from paul wheaton's glorious empire of web junk: cast iron skillet diatomaceous earth rocket mass heater sepp holzer raised garden beds raising chickens lawn care CFL flea control missoula heat permaculture