Re: mysql access exception after a long time
Re: mysql access exception after a long time
- Subject: Re: mysql access exception after a long time
- From: Kieran Kelleher <email@hidden>
- Date: Wed, 24 Jul 2013 14:37:00 -0400
I don't know. I use autoReconnect with MySQL 5.1 and it works fine on worker bee apps that get the occasional admin login every few months.
Regards, Kieran.
(Sent from my iPhone)
On Jul 23, 2013, at 2:29 AM, Pierre Gilquin <email@hidden> wrote:
> Thanks Kieran,
>
> I had this setting in my connection but I was not convinced that it was 100% safe.
>
>
> May be because I mixed 2 independants problems ?
>
> With jdbc utoReconnect set and MakeMySQLSuckALittleLess class from Hugi, I still get errors :
> WARN NSLog - <WOWorkerThread id=14 socket=Socket[addr=/127.0.0.1,port=58919,localport=2027]> Exception while sending response: java.net.SocketException: Broken pipe
>
>
> Is it related to mysql or it's a different problem ?
>
> Thanks in advance
>
>
> Pierre
>
>> Hugi ... that's overkill! Just add autoReconnect=true to the connection URL. :P ....... for example:
>> mydatabase.URL=jdbc:mysql://myhost/mydatabase?capitalizeTypenames=true&useBundledJdbcInfo=true&autoReconnect=true
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden