Thanks, I have added autoReconnect to the parameters. I used to set useUnicode=true&characterEncoding=UTF8 Is that still useful or is it now defaulted somewhere?
JPM Le 9 nov. 2012 à 14:32, Kieran Kelleher a écrit : > Yes, just add autoReconnect to the URL, for example: > > MyModel.URL=jdbc:mysql://myhost/mydatabase?capitalizeTypenames=true&useBundledJdbcInfo=true&autoReconnect=true > > > On Nov 9, 2012, at 6:00 AM, Jean Pierre Malrieu <[email protected]> wrote: > >> Hi, >> >> I am authenticating a user from another application. I receive the login >> from the other app, and let the user in. >> >> I am seing this error in my logs: >> >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:254) DEBUG >> org.apache.http.impl.conn.DefaultClientConnection - Receiving response: >> HTTP/1.1 200 OK >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:257) DEBUG >> org.apache.http.headers - << HTTP/1.1 200 OK >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Date: Fri, 09 Nov 2012 09:18:20 GMT >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Server: Apache/2.2.14 (Ubuntu) >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << X-Powered-By: PHP/5.3.2-1ubuntu4.17 >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Set-Cookie: >> symfony=eip1msbqf1tut82mtmkjgue527; path=/ >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Expires: Thu, 19 Nov 1981 08:52:00 GMT >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Cache-Control: no-store, no-cache, >> must-revalidate, post-check=0, pre-check=0 >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Pragma: no-cache >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Content-Length: 50 >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Keep-Alive: timeout=15, max=100 >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Connection: Keep-Alive >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:260) DEBUG >> org.apache.http.headers - << Content-Type: application/json >> Nov 09 10:17:53 grf[2001] (ResponseProcessCookies.java:122) DEBUG >> org.apache.http.client.protocol.ResponseProcessCookies - Cookie accepted: >> "[version: 0][name: symfony][value: eip1msbqf1tut82mtmkjgue527][domain: >> api.iepei.com][path: /][expiry: null]". >> Nov 09 10:17:53 grf[2001] (DefaultRequestDirector.java:540) DEBUG >> org.apache.http.impl.client.DefaultHttpClient - Connection can be kept >> alive for 15000 MILLISECONDS >> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << >> "{[\n]" >> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << " >> "user" : [\n]" >> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << >> "[0x9][0x9]{[\n]" >> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << >> "[0x9][0x9][0x9]"login": [0x9][0x9]"ehernand"[\n]" >> Nov 09 10:17:53 grf[2001] (Wire.java:63) DEBUG org.apache.http.wire - << >> "[0x9] }[\n]" >> Nov 09 10:17:53 grf[2001] (Wire.java:77) DEBUG org.apache.http.wire - << "}" >> Nov 09 10:17:53 grf[2001] (BasicClientConnectionManager.java:189) DEBUG >> org.apache.http.impl.conn.BasicClientConnectionManager - Releasing >> connection org.apache.http.impl.conn.ManagedClientConnectionImpl@1110b542 >> Nov 09 10:17:53 grf[2001] (BasicClientConnectionManager.java:219) DEBUG >> org.apache.http.impl.conn.BasicClientConnectionManager - Connection can be >> kept alive for 15000 MILLISECONDS >> Nov 09 10:17:53 grf[2001] (DefaultClientConnection.java:169) DEBUG >> org.apache.http.impl.conn.DefaultClientConnection - Connection >> 0.0.0.0:58398<->91.121.57.9:80 closed >> Nov 09 10:17:53 grf[2001] (ERXDatabaseContextDelegate.java:184) INFO >> er.transaction.adaptor.Exceptions - Database Exception occured: No >> operations allowed after connection >> closed.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last >> packet successfully received from the server was 41,690,527 milliseconds >> ago. The last packet sent successfully to the server was 41,690,527 >> milliseconds ago. is longer than the server configured value of >> 'wait_timeout'. You should consider either expiring and/or testing >> connection validity before use in your application, increasing the server >> configured values for client timeouts, or using the Connector/J connection >> property 'autoReconnect=true' to avoid this problem.at >> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> >> I don't understand why I get this error... >> Should I set JConnector property as advised? If the answer is yes, do I do >> this in the database url? >> >> Thanks in advance for your help. >> >> JPM >> >> >> >> >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/kelleherk%40gmail.com >> >> This email sent to [email protected] >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
