[jboss-user] [Beginner's Corner] - Re: JBoss connection pooling

[Peter Johnson]

Peter Johnson [https://community.jboss.org/people/peterj] created the discussion

"Re: JBoss connection pooling"

To view the discussion, visit: https://community.jboss.org/message/730423#730423

--------------------------------------------------------------
Which version of JBoss AS? I think that 7.x bechaves somewhat differnetly that earlier versions. But if you mean 6.x or earlier, there are some thoughts:

* If you fail to close a connection when you app responds to a request, the app server will "close" the connection for you. (There should be a log message about this)
* Closing a connection really means "placing the connection back into the connection pool"
* Opening a connection really means "obtaining a connection from the connection pool"
* No physical connections are made to the database until a connection is requested. At that time min-pool-size physical connections are created and placed into the pool, one ofwhich is returned to the requester.
* If a connection remains unused for idle-timeout-minutes, it is physically closed and removed from the pool. (If that causes less than min-pool-size connections to be open, a new physical connection is opened and added to the pool.)
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/730423#730423]

Start a new discussion in Beginner's Corner at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120416/3d2b68ad/attachment-0001.html