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]
