Hi Stefan!
I am wondering why the direct mode did not work. When we created the initial version of the store it did. To explain, the direct mode as opposed to the cursor mode is said to be faster, but only works when there is at least one open statement per connection. This was guaranteed with the initial version.
Unfortunately, I no longer have access to an SQLServer installation, so I can not track this down :(
Oliver
Stefan L�tzkendorf wrote:
resolved this using
jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=slide;SelectMethod=Cursor
instead of jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=slide
Stefan
Stefan L�tzkendorf wrote:
Hello,
has anybody ever observed such exception and has an idea what my problem could be.
Thanks in advance, Stefan
18 Aug 2004 11:47:32 - org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter - ERROR - SQL error 0 on /files/copy.html: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.prepareStatement(PoolingDriver.java:338)
at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.enumerateLocks(StandardRDBMSAdapter.java:362)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.enumerateLocks(AbstractRDBMSStore.java:613)
at org.apache.slide.store.AbstractStore.enumerateLocks(AbstractStore.java:958)
at org.apache.slide.store.ExtendedStore.fillLocksCache(ExtendedStore.java:1080)
at org.apache.slide.store.ExtendedStore.enumerateLocks(ExtendedStore.java:793)
at org.apache.slide.lock.LockImpl.isLockedInternal(LockImpl.java:615)
at org.apache.slide.lock.LockImpl.isLocked(LockImpl.java:492)
at org.apache.slide.lock.LockImpl.isLocked(LockImpl.java:448)
at org.apache.slide.lock.LockImpl.checkLock(LockImpl.java:423)
at org.apache.slide.lock.LockImpl.checkLock(LockImpl.java:387)
at org.apache.slide.content.ContentImpl.create(ContentImpl.java:439)
at org.apache.slide.macro.MacroImpl.copyObject(MacroImpl.java:690)
at org.apache.slide.macro.MacroImpl.copy(MacroImpl.java:216)
at org.apache.slide.webdav.method.CopyMethod.executeRequest(CopyMethod.java:231)
at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:380)
at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:164)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:233)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:587)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
at java.lang.Thread.run(Thread.java:534)
my store definitio is the following
<store name="MSSqlStore">
<nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter name="adapter">org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter</parameter>
<parameter name="driver">com.microsoft.jdbc.sqlserver.SQLServerDriver</parameter>
<parameter name="url">jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=slide</parameter>
<parameter name="user">********</parameter> <parameter name="password">*********</parameter> <parameter name="dbcpPooling">true</parameter> <parameter name="maxPooledConnections">10</parameter> <parameter name="isolation">SERIALIZABLE</parameter> <parameter name="compress">false</parameter> </nodestore> <contentstore> <reference store="nodestore" /> </contentstore> <securitystore> <reference store="nodestore" /> </securitystore> <lockstore> <reference store="nodestore" /> </lockstore> <revisiondescriptorsstore> <reference store="nodestore" /> </revisiondescriptorsstore> <revisiondescriptorstore> <reference store="nodestore" /> </revisiondescriptorstore> </store>
--------------------------------------------------------------------- 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
