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.createExcept
ion(SQLServerRDBMSAdapter.java:77)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevision
Content(StandardRDBMSAdapter.java:1086)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevisio
nContent(StandardRDBMSAdapter.java:1037)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisionC
ontent(AbstractRDBMSStore.java:836)
at
org.apache.slide.store.AbstractStore.createRevisionContent(AbstractS
tore.java:1434)
at
org.apache.slide.store.ExtendedStore.createRevisionContent(ExtendedS
tore.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(App
licationFilterChain.java:237)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
FilterChain.java:157)
at
org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:
141)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
licationFilterChain.java:186)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
FilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
Valve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja
va:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(Standar
dContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContext
Valve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:104)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentic
atorBase.java:540)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja
va:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
java:117)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja
va:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
lve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardVal
veContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.ja
va: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.jav
a:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proc
essConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.jav
a:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Thread
Pool.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]