It is not random. You just can not have two open statements inside a connection when in direct mode. Direct mode (default) should be faster, but cursor works in any case.
Oliver On Sun, 12 Dec 2004 11:24:21 +0000, Eirikur Hrafnsson <[EMAIL PROTECTED]> wrote: > I agree jTDS is best for MSSQL, for example it does not suffer from the > seemingly random "cannot create a cloned connection" problem that even > the latest Micro$haft driver does (you cannot reuse a Statement etc.) > > best regards > Eiki, idega. > > > > On 12.12.2004, at 00:34, Gregory Block wrote: > > > Also note that the MS-provided drivers are very, very 'sensitive'; > > move to jtds. :) > > > > On 10 Dec 2004, at 12:41, Oliver Zeigermann wrote: > > > >> The MacroImpl.copy does not seem to cause any problems. Most likely > >> the blocking problems with SQLServer are due to the fine grain locking > >> which is the default one in CVS head. I will set up a page in the Wiki > >> that describes how all this concurrency stuff works and describes why > >> there can be problems. For now switching back to "full" from > >> "fine-grain": > >> > >> <parameter name="sequential-mode">full</parameter> > >> > >> should fix this. Maybe you even would like to test the new > >> deadlock-retry stuff I described earlier. I will add SQLServer support > >> ASAP... > >> > >> Anyway, I still have almost 80 errors with the file store. E.g. > >> > >> testsuite\junit\xmltestcases\functional\copy\code\copy423.xml > >> > >> complains about this: > >> > >> <exceuteStep> > >> <method>LOCK</method> > >> <url>/slide/files/test/help-doc.html</url> > >> <XMLValueError> > >> <path>/prop/lockdiscovery/activelock/principal-URL/href</path> > >> <expectedValue>//slide/users/root</expectedValue> > >> <receivedValue>/slide/users/root</receivedValue> > >> </XMLValueError> > >> <result>ERROR</result> > >> <time>291</time> > >> </exceuteStep> > >> > >> I guess this is related to recent changes you have done, Stefan? > >> > >> Oliver > >> > >> On Thu, 9 Dec 2004 18:37:28 +0100, Oliver Zeigermann > >> <[EMAIL PROTECTED]> wrote: > >>> I haven't worked with SQL Server for a while. But the only thing I > >>> could imagine is the change in MacroImpl.copy that I made to allow > >>> copying read only resources. Maybe this is the problem? > >>> > >>> Oliver > >>> > >>> On Thu, 09 Dec 2004 17:59:03 +0100, Stefan L�tzkendorf > >>> > >>> > >>> <[EMAIL PROTECTED]> wrote: > >>>> Hello, > >>>> has any body experienced exceptions like this with MS SQL Server? > >>>> > >>>> Some testcases are passing, some are failing, some are hanging. > >>>> > >>>> (I'm on the HEAD) > >>>> > >>>> Thanks Stefan > >>>> > >>>>> org.apache.slide.common.ServiceAccessException: Service > >>>>> [EMAIL PROTECTED] access error : > >>>>> [Microsoft][SQLServer 2000 Driver for > >>>>> JDBC]System Exception: java.io.IOException: [Microsoft][SQLServer > >>>>> 2000 Driver for JDBC]Object has been closed.. > >>>>> at > >>>>> org.apache.slide.store.impl.rdbms.SQLServerRDBMSAdapter.createExcep > >>>>> tion(SQLServerRDBMSAdapter.java:77) > >>>>> at > >>>>> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisio > >>>>> nContent(StandardRDBMSAdapter.java:1086) > >>>>> at > >>>>> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisi > >>>>> onContent(StandardRDBMSAdapter.java:1037) > >>>>> at > >>>>> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevision > >>>>> Content(AbstractRDBMSStore.java:836) > >>>>> at > >>>>> org.apache.slide.store.AbstractStore.createRevisionContent(Abstract > >>>>> Store.java:1434) > >>>>> at > >>>>> org.apache.slide.store.ExtendedStore.createRevisionContent(Extended > >>>>> Store.java:516) > >>>>> at > >>>>> org.apache.slide.content.ContentImpl.create(ContentImpl.java:548) > >>>>> at > >>>>> org.apache.slide.macro.MacroImpl.copyObject(MacroImpl.java:829) > >>>>> at > >>>>> org.apache.slide.macro.MacroImpl.copy(MacroImpl.java:271) > >>>>> at > >>>>> org.apache.slide.webdav.method.CopyMethod.executeRequest(CopyMethod > >>>>> .java:210) > >>>>> at > >>>>> org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect > >>>>> (AbstractWebdavMethod.java:572) > >>>>> at > >>>>> org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWeb > >>>>> ,davMethod.java:443) > >>>>> at > >>>>> org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java: > >>>>> 151) > >>>>> at > >>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > >>>>> at > >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap > >>>>> plicationFilterChain.java:237) > >>>>> at > >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio > >>>>> nFilterChain.java:157) > >>>>> at > >>>>> org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java: > >>>>> 141) > >>>>> at > >>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap > >>>>> plicationFilterChain.java:186) > >>>>> at > >>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio > >>>>> nFilterChain.java:157) > >>>>> at > >>>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe > >>>>> rValve.java:214) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:104) > >>>>> at > >>>>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j > >>>>> ava:520) > >>>>> at > >>>>> org.apache.catalina.core.StandardContextValve.invokeInternal(Standa > >>>>> rdContextValve.java:198) > >>>>> at > >>>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContex > >>>>> tValve.java:152) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:104) > >>>>> at > >>>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenti > >>>>> catorBase.java:540) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:102) > >>>>> at > >>>>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j > >>>>> ava:520) > >>>>> at > >>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve > >>>>> .java:137) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:104) > >>>>> at > >>>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve > >>>>> .java:117) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:102) > >>>>> at > >>>>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j > >>>>> ava:520) > >>>>> at > >>>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineV > >>>>> alve.java:109) > >>>>> at > >>>>> org.apache.catalina.core.StandardValveContext.invokeNext(StandardVa > >>>>> lveContext.java:104) > >>>>> at > >>>>> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j > >>>>> ava:520) > >>>>> at > >>>>> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: > >>>>> 929) > >>>>> at > >>>>> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java: > >>>>> 160) > >>>>> at > >>>>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.ja > >>>>> va:799) > >>>>> at > >>>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.pro > >>>>> cessConnection(Http11Protocol.java:705) > >>>>> at > >>>>> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.ja > >>>>> va:577) > >>>>> at > >>>>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threa > >>>>> dPool.java:683) > >>>>> at java.lang.Thread.run(Thread.java:534) > >>>>> 09 Dec 2004 17:42:55 - > >>>>> org.apache.slide.transaction.SlideTransaction - WARNING - > >>>>> Rollback failure: Resource manager > >>>>> org.apache.slide.store.impl.rdbms.JDBCStore@ > >>>>> 185f293 Error code XA_RBCOMMFAIL in Transaction 123 xid > >>>>> [EMAIL PROTECTED]@12d8acd in thread http-8081-Processor32 > >>>>> http-8081-Processor32, 09-Dez-2004 17:42:55, john2, COPY, 500 > >>>>> "Internal Server Error", 94 ms, /files/help-doc.html > >>>> > >>>> -- > >>>> Stefan L�tzkendorf -- [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] > >> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > Best Regards > > Eirikur S. Hrafnsson, [EMAIL PROTECTED] > Chief Software Engineer > Idega Software > http://www.idega.com > > > > > --------------------------------------------------------------------- > 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]
