jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Mueller" <thomas.tom.muel...@gmail.com>
Subject Re: About the parameter config of Mysql autoReconnect
Date Fri, 17 Nov 2006 13:28:48 GMT
Hi,

The problem is that this MySQL feature only works if autocommit is on
(and even then, it doesn't work transparently). However, in the
SimpleDbPersistenceManager, autocommit is switched off. So the feature
(autoReconnect=true) doesn't work. See also:

http://issues.apache.org/jira/browse/JCR-576

Is using an other database no option for you? Why does the connection
to the database breaks by the way?

Thomas


On 11/17/06, wendy Lee <hawkliwend@gmail.com> wrote:
> Yes,I config the parameter follow your mentioned.
>
> but I caught such exception :
> -----------------------------------------------------------------------------------------------------------------------------------------
> This is My config file:
> <PersistenceManager class="
> org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
>           <param name="driver" value="com.mysql.jdbc.Driver"/>
>           <param name="url"
> value="jdbc:mysql://localhost:3306/dbname?autoReconnect=true"/>
>           <param name="user" value=""/>
>           <param name="password" value=""/>
>           <param name="schema" value="mysql"/>
> <param name="schemaObjectPrefix" value="${wsp.name}_"/>
>           <param name="externalBlobs" value="true"/>
>         </PersistenceManager>
> ------------------------------------------------------------------------------------------------------------------------------------------
> java.net.SocketException
> MESSAGE: Broken pipe
> STACKTRACE:
> java.net.SocketException: Broken pipe
>     at java.net.SocketOutputStream.socketWrite0(Native Method)
>     at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
>     at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
>     at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java
> :65)
>     at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
>     at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2637)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554)
>     at com.mysql.jdbc.ServerPreparedStatement.serverExecute(
> ServerPreparedStatement.java:1169)
>     at com.mysql.jdbc.ServerPreparedStatement.executeInternal(
> ServerPreparedStatement.java:693)
>     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:794)
>     at org.apache.jackrabbit.core.state.db.DatabasePersistenceManager.exists
> (DatabasePersistenceManager.java:713)
>     at
> org.apache.jackrabbit.core.state.SharedItemStateManager.hasNonVirtualItemState
> (SharedItemStateManager.java:878)
>     at org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(
> SharedItemStateManager.java:269)
>     at
> org.apache.jackrabbit.core.version.VersionItemStateProvider.hasItemState(
> VersionItemStateProvider.java:139)
>     at org.apache.jackrabbit.core.state.SharedItemStateManager.hasItemState(
> SharedItemStateManager.java:274)
>     at org.apache.jackrabbit.core.state.LocalItemStateManager.hasItemState(
> LocalItemStateManager.java:179)
>     at org.apache.jackrabbit.core.state.XAItemStateManager.hasItemState(
> XAItemStateManager.java:262)
>     at org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState
> (SessionItemStateManager.java:161)
>     at org.apache.jackrabbit.core.ItemManager.createItemInstance(
> ItemManager.java:461)
>     at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:319)
>     at org.apache.jackrabbit.core.NodeImpl.getNode(NodeImpl.java:2416)
>     at com.hongrui.weekee.operation.impl.QueryOperationImpl.getVideoRingData
> (QueryOperationImpl.java:1779)
>     at com.hongrui.weekee.service.impl.QueryServiceImpl.getVideoRingData(
> QueryServiceImpl.java:464)
>     at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>     at java.lang.reflect.Method.invoke(Method.java:585)
>     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(
> ContinuationInterpreter.java:1134)
>     at
> org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(
> ContinuationInterpreter.java:190)
>     at
> org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(
> ContinuationInterpreter.java:138)
>     at org.mozilla.javascript.continuations.InterpretedFunctionImpl.call(
> InterpretedFunctionImpl.java:121)
>     at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244)
>     at
> org.apache.cocoon.components.flow.javascript.fom.FOM_JavaScriptInterpreter.callFunction
> (FOM_JavaScriptInterpreter.java:758)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.CallFunctionNode.invoke(
> CallFunctionNode.java:138)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:46)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke
> (PreparableMatchNode.java:130)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(
> PipelineNode.java:142)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
> PipelinesNode.java:92)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:234)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:176)
>     at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(
> TreeProcessor.java:248)
>     at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(
> MountNode.java:117)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:46)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke
> (PreparableMatchNode.java:130)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(
> PipelineNode.java:142)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
> PipelinesNode.java:92)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:234)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:176)
>     at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(
> TreeProcessor.java:248)
>     at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(
> MountNode.java:117)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:46)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invoke
> (PreparableMatchNode.java:130)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(
> PipelineNode.java:142)
>     at
> org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes
> (AbstractParentProcessingNode.java:68)
>     at
> org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
> PipelinesNode.java:92)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:234)
>     at
> org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(
> ConcreteTreeProcessor.java:176)
>     at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(
> TreeProcessor.java:248)
>     at org.apache.cocoon.Cocoon.process(Cocoon.java:679)
>     at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java
> :1154)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
>     at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java
> :445)
>     at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java
> :356)
>     at org.mortbay.jetty.security.SecurityHandler.handle(
> SecurityHandler.java:179)
>     at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java
> :226)
>     at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java
> :627)
>     at org.mortbay.jetty.handler.ContextHandlerCollection.handle(
> ContextHandlerCollection.java:149)
>     at org.mortbay.jetty.handler.HandlerCollection.handle(
> HandlerCollection.java:123)
>     at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java
> :141)
>     at org.mortbay.jetty.Server.handle(Server.java:269)
>     at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java
> :430)
>     at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(
> HttpConnection.java:687)
>     at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:492)
>     at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199)
>     at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
>     at org.mortbay.jetty.nio.HttpChannelEndPoint.run(
> HttpChannelEndPoint.java:270)
>     at org.mortbay.thread.BoundedThreadPool$PoolThread.run(
> BoundedThreadPool.java:475)
>
>

Mime
View raw message