Yes I know the randomness is when you have a pool of connections and
the error doesn't really show up until much later in a totally
different part of your code making it impossible to find where you
where so bold to open more than one statement. The jTDS driver is also
faster so I don't see the point of anyone using the MS driver.
On 12.12.2004, at 22:51, Oliver Zeigermann wrote:
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.createExc
ep
tion(SQLServerRDBMSAdapter.java:77)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevis
io
nContent(StandardRDBMSAdapter.java:1086)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createRevi
si
onContent(StandardRDBMSAdapter.java:1037)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createRevisi
on
Content(AbstractRDBMSStore.java:836)
at
org.apache.slide.store.AbstractStore.createRevisionContent(Abstra
ct
Store.java:1434)
at
org.apache.slide.store.ExtendedStore.createRevisionContent(Extend
ed
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(CopyMeth
od
.java:210)
at
org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedire
ct
(AbstractWebdavMethod.java:572)
at
org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractW
eb
,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(Applicat
io
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(Applicat
io
nFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrap
pe
rValve.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
lveContext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline
.j
ava:520)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(Stan
da
rdContextValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardCont
ex
tValve.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
lveContext.java:104)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authen
ti
catorBase.java:540)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
lveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline
.j
ava:520)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostVal
ve
.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
lveContext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportVal
ve
.java:117)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
lveContext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline
.j
ava:520)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngin
eV
alve.java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(Standard
Va
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.jav
a:
160)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.
ja
va:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.p
ro
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(Thr
ea
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]
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]
