users@glassfish.java.net

Re: Question about using JDBC DataSources in EJB

From: Steve Essery <Steve.Essery_at_Sun.COM>
Date: Tue, 31 Jul 2007 10:03:57 +0100

glassfish_at_javadesktop.org wrote:
> Since the connections are pooled and are reused, over the period, you may run out of cursors.
> It is a good programming practice to close statement / resultset after use.
>
There is an option in the advanced pool settings to provide relief from
this sort of leak (if you run into it) while you work on discovering the
source and correcting it... setting the max-connection-sage-count to a
value greater than 0 places a limit on the number of times a connection
can be used from the pool before it is destroyed.
> [Message sent by forum member 'jr158900' (jr158900)]
>
> http://forums.java.net/jive/thread.jspa?messageID=227085
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>