1) Try to increase your connection timeout 2) Double check if you are releasing the connections correctly. 3) Use a connection pooling mechanism :) C3P0 is a good one and easy to use
If you are using hibernate, it will be very easy to configure it. HTH On Thu, Jun 18, 2009 at 2:11 PM, Ward Loockx <[email protected]> wrote: > > > Hello Pedro, > > > Thanks for your reply! > > > Here are the answers > > > 1) What is your connection timeout? > -> connect timeout 5 > 2) Are your application and database in the same machine? > -> No (the DAO's make multiple connections to mysql servers and non of them > are installed on the localhost) > 3) Are you using some kind of connection pool mechanism? If so, what are > you > using? > -> Don't think so > 4) Is it ocurring when your execute some specific query or it occurs > anytime? > -> No, it just occurs after 20minutes. (every connection). So I get > multiple errors in my application > 5) What engine are you using(MyISAM, InnoDB, ...) ? > -> MyISAM > > > Thanks, > Ward > > > > On Thursday 18 June 2009 06:28:26 pm Pedro Sena wrote: > > I had this problem before. > > > > It's related to mysql(obviously) not to flex, but I'll try to help you. > > > > To do that, please answer some questions: > > > > 1) What is your connection timeout? > > 2) Are your application and database in the same machine? > > 3) Are you using some kind of connection pool mechanism? If so, what are > > you using? > > 4) Is it ocurring when your execute some specific query or it occurs > > anytime? > > 5) What engine are you using(MyISAM, InnoDB, ...) ? > > > > PS > > > > On Thu, Jun 18, 2009 at 1:04 PM, Ward Loockx <[email protected]> wrote: > > > Hello, > > > > > > I'm having a problem with my connections to the mysql server that are > > > timing out(and get the communicationsException). We use > > > autoreconnect=true when creating the connections, the problem is that > > > whole application is crashing at this point because the connection has > > > been lost. The Dao's just create one connection at startup for all > > > clients (that should stay open). Does somebody has experience with this > > > problem or any advice how to keep the connections open? > > > > > > Here is the stacktrace > > > > > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > > > link failure > > > Last packet sent to the server was 19 ms ago. > > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > > Method) > > > at > > > > > > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAc > > >cessorImpl.java:39) at > > > > > > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConst > > >ructorAccessorImpl.java:27) at > > > java.lang.reflect.Constructor.newInstance(Constructor.java:513) at > > > com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > > > at > > > > com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) > > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3009) > > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2895) > > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) > > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) > > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) > > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) > > > at > > > > > > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1 > > >761) at > > > > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912 > > >) at > > > > > > > com.dnxlive.cammer.remoting.CammerService.getShortcuts(CammerService.java > > >:86) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > > at > > > > > > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > > >:39) at > > > > > > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI > > >mpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) > > > at > > > > > > > flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter. > > >java:421) at > > > > > > > flex.messaging.services.RemotingService.serviceMessage(RemotingService.ja > > >va:183) at > > > > flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:150 > > >3) at > > > > > > > flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint > > >.java:884) at > > > > > > > flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilt > > >er.java:121) at > > > flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158) > > > at > > > > flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44) > > > at > > > > > > > flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter > > >.java:67) at > > > > > > > flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilt > > >er.java:146) at > > > > > > > flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:2 > > >78) at > > > > flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322 > > >) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > > at > > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat > > >ionFilterChain.java:290) at > > > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte > > >rChain.java:206) at > > > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve > > >.java:233) at > > > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve > > >.java:191) at > > > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > > >128) at > > > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > > >102) at > > > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j > > >ava:109) at > > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:28 > > >6) at > > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845 > > >) at > > > > > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(H > > >ttp11Protocol.java:583) at > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > > > at java.lang.Thread.run(Thread.java:619) > > > Caused by: java.net.SocketException: Connection reset > > > at java.net.SocketInputStream.read(SocketInputStream.java:168) > > > at > > > > > > > com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:1 > > >13) at > > > > > > > com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecess > > >ary(ReadAheadInputStream.java:160) at > > > > > > > com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:1 > > >88) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2452) > > > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2906) > > > ... 36 more > > > > > > Thanks in advance! > > > Ward Loockx > > > > -- /** * Pedro Sena * Systems Architect * Sun Certified Java Programmer * Sun Certified Web Component Developer */
