persistence@glassfish.java.net

Re: Losing dbase connection

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Fri, 29 Sep 2006 00:46:35 -0700

Peter,

Can you please resend this to the users alias? The exception most probably
means that you didn't setup the connection pool validation properly, but
you'll get a response from a wider audience.

thanks,
-marina

Peter Havelaar wrote:
> Hello everyone,
>
> I am running GF b48 with hibernate and mysql 5.0
> It seems that sometimes overnight for some reason the database
> connection gets lost and I get :
>
> org.hibernate.exception.JDBCConnectionException: could not execute query
> The only solution is to restart glassfish.
> Needless to say, this musn't happen in a production environment, but I
> don't really know why this happens.
>
> Regards,
> Peter Havelaar