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
posted
0
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
posted
0
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?