Connection Pooling in Weblogic 6.1

[Guest_imported]

Let me start out by saying I am new to weblogic. I am trying to use the connection pooling functionality but I am having problems finding information on exactly how the pool manages its connections. For instance when I get a connection from the pool, do I explicitly have to return to the pool? If so what is the syntax for doing this. I have also tried to pass the connection between methods and it seems as though the pool closes the connection during the pass. Any suggestions?

Thanks
-J

 

[wushutwist]

To return the Connection to the pool you just have to call Connection.close(), don't worry it won't physically close the Connection. I have never had problems passing a Connection between methods, I assume it must be a code issue but the only way to really tell is if you post some code.

 

[Guest_imported]

I fixed the problem with passing the connections between methods. It was a coding error on my part.

I have a question regarding the monitoring of the active pools using the console. Could you tell me what the differences between Connections High, Connections Total, and Connection are?

Thanks

 

[wushutwist]

Connections High is the most active connections since the last reboot.

Connections Total is a running tally of total number of connections that WebLogic has opened to the database.

Connections is the current number of connections.

Max Capacity is maximum number of connections allowed.