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