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]
