users@glassfish.java.net

How is a connection pool managing idle connections ?

From: <glassfish_at_javadesktop.org>
Date: Tue, 07 Apr 2009 00:09:52 PDT

Hello


Yesterday I submitted this bug
https://glassfish.dev.java.net/issues/show_bug.cgi?id=7527

Since then, it has been marked as invalid and the reason is:

[i]
It works according to the settings of "idle-timeout".
If the connection is unused for "idle-timeout" period, it will be destroyed and
a new connection will be created.

Please refer :
http://docs.sun.com/app/docs/doc/820-4332/create-jdbc-connection-pool-1?a=view
[/i]

Please, take the same test case but change the non transactional datasource by any transactional datasource (non XA ou XA).
In that case, after this new test, the monitoring page will show 5 created connections, 4 destroyed connections and one free connection. No more connection destroyed nor created.

Can you tell me which of this two behaviours is the right one ?
If both are "right", could you explain why those two behaviours are inconsistent ?

Note: I have pointed the non transactional case has a bug since it is consuming resources for nothing.

Thanks a lot for all the information you could provide to help me understand the right usage.


Bye
[Message sent by forum member 'vkoniecz' (vkoniecz)]

http://forums.java.net/jive/thread.jspa?messageID=340905