inactivity time out, min and max settings for the external connection pool
402008Nov 17 2009 — edited Nov 18 2009I have just started using the External connection pool with Toplink. And I did the following :
data-sources.xml:
url="jdbc:oracle:thin:@//localhost:1521/test" inactivity-timeout="120" min-connections="2" max-connections="5"
sessions.xml:
<datasource>jdbc/test</datasource>
<uses-external-connection-pool>true</uses-external-connection-pool>
I use the Serversession and I get the server session as below:
myServerSession =(ServerSession) SessionManager.getManager().getSession(connectionParameters);
The application is working fine. However i was monitoring the number of sessions on the oracle database in v$session. And it seems the connection is opened and closed immediately once the query is executed. The inactivity time out, min and max connection settings in the data-sources.xml has no affect.
The question is, did i do something wrong? How can I make sure that the inactivity time out, min and max connection settings are used properly?
Thanks in advance.
Potu