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

sweth smile do-not-reply at jboss.com
Mon Apr 16 16:40:20 EDT 2012


sweth smile [https://community.jboss.org/people/sweth_smile] created the discussion

"JBoss connection pooling"

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

--------------------------------------------------------------
Hi All,
I am new to JBoss AS. I am using Jboss connection pooling to connect to MS- SQL DB.
In my code first i am getting a new connection, and i execute the query and get the results. But i didnt close the connection explictly.
During second call to the code i am checking whether  the connection obj is null if so i am creating a new connection else i am resuing the existing connection.
My questions are:
1. What will happen to a connection after i execute a query and didnt issue close? How long will it be active and what will be its state?
2. how will jboss release a connection from pool?

Please advise on the same
Thanks
-Swetha
--------------------------------------------------------------

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

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/30aced3f/attachment.html 


More information about the jboss-user mailing list