Hello all,
I have a quertion in relation to release a database connection properly.
I am using ServerSession to connect to a database and acquire a ClientSession to send the SQL Query through the client to the database. After I have done this, I release the client session:
Now some strange behavior that I have recognized:
- while configuring the connection pool to the size from 0 to 1 connections, the application opens always 2 connections on the database side.
- After I read the following discussion:
1375568
I decided not to close the serverconnection with the nice and beautifull logout() function.
After the decision was made, I came today in and got a message that I have too many, ... 5 to be exactly connections on tha database side open.
=> better to close the serverSessions???
For further information:
I am using Toplink in a web application. The application is structured in a way that I have two projects, a model project which pulls the data from the database and a view project that presents the data in the browser.
In the model I am using POJO's to have a simple life.
Now, is there a better way than just leaving the connections open? My DBA would be very pleased, if I could get an answer how to disconnect the serverSessions in a propper way.
Best regards,