Hi,
never used mysql (so take this with a pinch of salt ;-)), but it seems that by default reconnected connections set to 'read-only' mode. Did you try to set failOverReadOnly=false
http://dev.mysql.com/doc/connector/j/en/index.html#id2423002
In jdbc-connection-descriptor you should set useAutoCommit="1", this guarantee that all connections returned to pool set with autoCommit 'true'. Only in this case autoReconnect seems to work in mysql.
http://db.apache.org/ojb/docu/guides/repository.html#useAutoCommit
If you don't have succeed in doing so, you can specify a 'validatioQuery' to check connection before delivered by the connection-pool
http://db.apache.org/ojb/docu/guides/repository.html#connection-pool-N10230
regards, Armin
Noureddine BEKRAR wrote:
I reproduced the exeption by stopping and restarting the sql server.
the probleme is that OJB dont auto-Reconnect in spite of putting in my repository.xml in the connection declaration dbalias="//localhost/MyDB?autoReconnect=true"
How can i tell to OJb to auto reconnect?
----- Original Message ----- From: "Noureddine BEKRAR" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Friday, August 13, 2004 9:57 AM
Subject: org.apache.ojb.broker.PersistenceBrokerSQLException
Hi all,
I have a SQL probleme, it seems like the connection died after some time, it happen only for the OJB connection, because I have another connection that use classic java connection managed with a connection pool, this kind of connection dont throw any exception at the same time the ojb connection throws that exception.
Did anyone had the same problem?
org.apache.ojb.broker.PersistenceBrokerSQLException: java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1388)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAcces sImpl.java:557)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(PersistenceBrok erImpl.java:1232)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(Persi stenceBrokerImpl.java:1355)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Persist enceBrokerImpl.java:1334)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(D elegatingPersistenceBroker.java:306)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(D elegatingPersistenceBroker.java:306)
at jouve.extradim.backoffice.entity.dao.ProjectDAO.retrieve(ProjectDAO.java:37)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 )
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:230)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244)
at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti nuationInterpreter.java:1134)
at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti nuationInterpreter.java:190)
at org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti nuationInterpreter.java:138)
at org.mozilla.javascript.continuations.InterpretedFunctionImpl.call(Interprete dFunctionImpl.java:121)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244)
at org.mozilla.javascript.ScriptableObject.callMethod(ScriptableObject.java:159 1)
at org.apache.cocoon.components.flow.javascript.fom.FOM_JavaScriptInterpreter.h andleContinuation(FOM_JavaScriptInterpreter.java:788)
at org.apache.cocoon.components.treeprocessor.sitemap.CallFunctionNode.invoke(C allFunctionNode.java:120)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.SelectNode.invoke(SelectN ode.java:97)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.buildPipeline(TreeP rocessor.java:295)
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod e.java:94)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.buildPipeline(TreeP rocessor.java:295)
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod e.java:94)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.buildPipeline(TreeP rocessor.java:295)
at org.apache.cocoon.components.source.impl.SitemapSource.init(SitemapSource.ja va:348)
at org.apache.cocoon.components.source.impl.SitemapSource.<init>(SitemapSource. java:223)
at org.apache.cocoon.components.source.impl.SitemapSourceFactory.getSource(Site mapSourceFactory.java:64)
at org.apache.excalibur.source.impl.SourceResolverImpl.resolveURI(SourceResolve rImpl.java:208)
at org.apache.cocoon.components.CocoonComponentManager.resolveURI(CocoonCompone ntManager.java:500)
at org.apache.cocoon.portal.coplet.adapter.impl.URICopletAdapter.streamContent( URICopletAdapter.java:125)
at org.apache.cocoon.portal.coplet.adapter.impl.URICopletAdapter.streamContent( URICopletAdapter.java:89)
at org.apache.cocoon.portal.coplet.adapter.impl.AbstractCopletAdapter.toSAX(Abs tractCopletAdapter.java:149)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultCopletAspect.toS AX(DefaultCopletAspect.java:75)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.HistoryAspect.toSAX(His toryAspect.java:114)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.impl.AspectRenderer.toSAX(AspectRen derer.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.AbstractCompositeAspect .processLayout(AbstractCompositeAspect.java:86)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.CompositeContentAspect. processItem(CompositeContentAspect.java:112)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.AbstractCompositeAspect .toSAX(AbstractCompositeAspect.java:61)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.CompositeContentAspect. toSAX(CompositeContentAspect.java:83)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.ParameterAspect.toSAX(P arameterAspect.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.XSLTAspect.toSAX(XSLTAs pect.java:121)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.impl.AspectRenderer.toSAX(AspectRen derer.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.AbstractCompositeAspect .processLayout(AbstractCompositeAspect.java:86)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.CompositeContentAspect. processItem(CompositeContentAspect.java:112)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.AbstractCompositeAspect .toSAX(AbstractCompositeAspect.java:61)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.CompositeContentAspect. toSAX(CompositeContentAspect.java:83)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.ParameterAspect.toSAX(P arameterAspect.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.XSLTAspect.toSAX(XSLTAs pect.java:121)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.impl.AspectRenderer.toSAX(AspectRen derer.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.AbstractCompositeAspect .processLayout(AbstractCompositeAspect.java:86)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.TabContentAspect.toSAX( TabContentAspect.java:119)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.HistoryAspect.toSAX(His toryAspect.java:114)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.ParameterAspect.toSAX(P arameterAspect.java:85)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.XSLTAspect.toSAX(XSLTAs pect.java:121)
at org.apache.cocoon.portal.layout.renderer.aspect.impl.DefaultRendererContext. invokeNext(DefaultRendererContext.java:62)
at org.apache.cocoon.portal.layout.renderer.impl.AspectRenderer.toSAX(AspectRen derer.java:85)
at org.apache.cocoon.portal.impl.PortalManagerImpl.showPortal(PortalManagerImpl .java:75)
at org.apache.cocoon.portal.impl.PortletPortalManager.showPortal(PortletPortalM anager.java:240)
at org.apache.cocoon.portal.generation.PortalGenerator.generate(PortalGenerator .java:59)
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLP ipeline(AbstractProcessingPipeline.java:545)
at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline .processXMLPipeline(AbstractCachingProcessingPipeline.java:173)
at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(Abs tractProcessingPipeline.java:490)
at org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(Seri alizeNode.java:120)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTyp eNode.java:138)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:277)
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod e.java:103)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:277)
at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod e.java:103)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:49)
at org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok e(PreparableMatchNode.java:130)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel ineNode.java:126)
at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo keNodes(AbstractParentProcessingNode.java:72)
at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe linesNode.java:101)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:336)
at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess or.java:277)
at org.apache.cocoon.Cocoon.process(Cocoon.java:639)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1098)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.in vokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 )
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 )
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:533)
at java.lang.Thread.run(Thread.java:534)
** END NESTED EXCEPTION **
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]