# 12
dear
i have been running this app with autoReconnect=true for a while now but this doesnt seem to help. after following your steps ..
1) with validatio turned on and mysql start stopping i get the below entry in the log file .. but the application is useable .. unlike my problem when i get the perpared statement problem and the app gets frozen ... i dont seem to be able to repoduce the RAR5074 follwing your steps ... please help me fix this problem
[#|2006-05-10T12:16:54.094+0700|SEVERE|sun-appserver-pe8.2|javax.enterprise.res ource.resourceadapter|_ThreadID=14;|jdbc.exc_tx_level|#]
[#|2006-05-10T12:16:54.095+0700|WARNING|sun-appserver-pe8.2|javax.enterprise.re source.resourceadapter|_ThreadID=14;|RAR5117 : Failed to obtain/create connection. Reason : The isolation level could not be set: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.IOException
MESSAGE: Connection reset by peer
STACKTRACE:
java.io.IOException: Connection reset by peer
at sun.nio.ch.FileDispatcher.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:21)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233)
at sun.nio.ch.IOUtil.read(IOUtil.java:206)
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:207)
at com.sun.enterprise.server.ss.ASInputStream.read(ASInputStream.java:82)
at com.sun.enterprise.server.ss.ASInputStream.read(ASInputStream.java:73)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(Re adAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:3510)
at com.mysql.jdbc.jdbc2.optional.ConnectionWrapper.getTransactionIsolation(Connect ionWrapper.java:316)
at com.sun.gjc.spi.ManagedConnectionFactory.resetIsolation(ManagedConnectionFactor y.java:404)
at com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:304)
at com.sun.enterprise.resource.LocalTxConnectorAllocator.fillInResourceObjects(Loc alTxConnectorAllocator.java:70)
at com.sun.enterprise.resource.IASNonSharedResourcePool.getUnenlistedResource(IASN onSharedResourcePool.java:431)
at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:355)
at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:250)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:213)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:17 4)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(Conne ctionManagerImpl.java:276)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(Connecti onManagerImpl.java:190)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(Connecti onManagerImpl.java:121)
at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:70)
at com.sun.sql.rowset.internal.CachedRowSetXReader.connect(CachedRowSetXReader.jav a:344)
at com.sun.sql.rowset.internal.CachedRowSetXReader.readData(CachedRowSetXReader.ja va:126)
at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:950)
at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:1410)
at com.sun.data.provider.impl.CachedRowSetDataProvider.checkExecute(CachedRowSetDa taProvider.java:1219)
at com.sun.data.provider.impl.CachedRowSetDataProvider.absolute(CachedRowSetDataPr ovider.java:283)
at com.sun.data.provider.impl.CachedRowSetDataProvider.getRowKeys(CachedRowSetData Provider.java:232)
at com.sun.data.provider.impl.CachedRowSetDataProvider.cursorFirst(CachedRowSetDat aProvider.java:351)
at com.sun.data.provider.impl.CachedRowSetDataProvider.setCachedRowSet(CachedRowSe tDataProvider.java:182)
at com.sun.data.provider.impl.CachedRowSetDataProvider.close(CachedRowSetDataProvi der.java:209)
at clockwork.register.destroy(register.java:320)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 580)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.afterPhase(ViewHandlerImpl.ja va:466)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:235)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
at sun.reflect.GeneratedMethodAccessor217.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at clockwork.SecurityFilter.doFilter(SecurityFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)
at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)
at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)
at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)
** END NESTED EXCEPTION **
Last packet sent to the server was 3 ms ago.|#]
[#|2006-05-10T12:16:54.108+0700|WARNING|sun-appserver-pe8.2|javax.enterprise.re source.resourceadapter|_ThreadID=14;|RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: The isolation level could not be set: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.IOException
MESSAGE: Connection reset by peer
STACKTRACE:
java.io.IOException: Connection reset by peer
at sun.nio.ch.FileDispatcher.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:21)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:233)
at sun.nio.ch.IOUtil.read(IOUtil.java:206)
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:207)
at com.sun.enterprise.server.ss.ASInputStream.read(ASInputStream.java:82)
at com.sun.enterprise.server.ss.ASInputStream.read(ASInputStream.java:73)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(Re adAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:824)
at com.mysql.jdbc.Connection.getTransactionIsolation(Connection.java:3510)
at com.mysql.jdbc.jdbc2.optional.ConnectionWrapper.getTransactionIsolation(Connect ionWrapper.java:316)
at com.sun.gjc.spi.ManagedConnectionFactory.resetIsolation(ManagedConnectionFactor y.java:404)
at com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:304)
at com.sun.enterprise.resource.LocalTxConnectorAllocator.fillInResourceObjects(Loc alTxConnectorAllocator.java:70)
at com.sun.enterprise.resource.IASNonSharedResourcePool.getUnenlistedResource(IASN onSharedResourcePool.java:431)
at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:355)
at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:250)
at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:213)
at com.sun.enterprise.resource.PoolManagerImpl.getResource(PoolManagerImpl.java:17 4)
at com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(Conne ctionManagerImpl.java:276)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(Connecti onManagerImpl.java:190)
at com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(Connecti onManagerImpl.java:121)
at com.sun.gjc.spi.DataSource.getConnection(DataSource.java:70)
at com.sun.sql.rowset.internal.CachedRowSetXReader.connect(CachedRowSetXReader.jav a:344)
at com.sun.sql.rowset.internal.CachedRowSetXReader.readData(CachedRowSetXReader.ja va:126)
at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:950)
at com.sun.sql.rowset.CachedRowSetXImpl.execute(CachedRowSetXImpl.java:1410)
at com.sun.data.provider.impl.CachedRowSetDataProvider.checkExecute(CachedRowSetDa taProvider.java:1219)
at com.sun.data.provider.impl.CachedRowSetDataProvider.absolute(CachedRowSetDataPr ovider.java:283)
at com.sun.data.provider.impl.CachedRowSetDataProvider.getRowKeys(CachedRowSetData Provider.java:232)
at com.sun.data.provider.impl.CachedRowSetDataProvider.cursorFirst(CachedRowSetDat aProvider.java:351)
at com.sun.data.provider.impl.CachedRowSetDataProvider.setCachedRowSet(CachedRowSe tDataProvider.java:182)
at com.sun.data.provider.impl.CachedRowSetDataProvider.close(CachedRowSetDataProvi der.java:209)
at clockwork.register.destroy(register.java:320)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 580)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.afterPhase(ViewHandlerImpl.ja va:466)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:235)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
at sun.reflect.GeneratedMethodAccessor217.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:500)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:257)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at clockwork.SecurityFilter.doFilter(SecurityFilter.java:97)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFil terChain.java:210)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterCha in.java:55)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.ja va:161)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain .java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 263)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextVal ve.java:225)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 173)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:13 2)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:551)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:933)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:189)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.doProcess(ProcessorTask. java:604)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.ja va:475)
at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask .java:371)
at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:264)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:281)
at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:83)
** END NESTED EXCEPTION **
Last packet sent to the server was 3 ms ago.]|#]