The connection is checked for any transaction wrt this Connection instance.
The GCMInIdle 10000 (10 secs) time what is set is ok. can be increased to 20000.
And u can set in the DB the no of the Connections allowed and in the jboss.jcml - MaxSize can be set to 75 %.
set the IdleTimeout to 5000 ( 5 secs ) since the already set value is too less.
Many thanks for your reply.
Thanks for the notes on config. values.
When I put connections back into the pool, what messages should I see? How do I know that they are put back?
If the connection is checked for transactions when using non-transactional databases, will it prevent the connection being released - or am I paranoid here?