My google login is: douglas.clarke_at_rogers.com
Doug
-----Original Message-----
From: Marina Vatkina [mailto:Marina.Vatkina_at_Sun.COM]
Sent: Thursday, October 02, 2008 1:33 PM
To: users_at_glassfish.dev.java.net
Cc: persistence_at_glassfish.dev.java.net
Subject: Re: JPA problem with connection
This is the right thing to do if you use GlassFish connection pool.
Regards,
-marina
Dru Devore wrote:
> I think I have solved my problem but I wanted to check on the solution
> to make sure I was doing it right and to see if there is a better
> solution. I was having a problem with my JDBC connections. The problem
> is that if I lose connectivity with the DB the connections all die which
> is expected but they don't seem to recover for an extended period of time.
>
> What I have done to solve the problem:
> I turned on Connection Validation using table validation (because I
> could go hours without any commits) and On Any Failure Close All
> connections.
>
> Once I made these changes seems to work the way I need it to, solving
> the problem.
>
> So my question now is am I doing this right or is there a better way of
> doing connection recovery with EJB3?
>
> Can I do it from the persistence.xml?
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net For
> additional commands, e-mail: users-help_at_glassfish.dev.java.net