Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inactivity time out, min and max settings for the external connection pool

402008Nov 17 2009 — edited Nov 18 2009
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2009
Added on Nov 17 2009
3 comments
3,089 views