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]
