Page: http://wiki.cocoondev.org/Wiki.jsp?page=MsSQL, version: 8 on Mon Feb 3
23:10:18 2003 by 212.212.102.73
-
<dburl>jdbc:microsoft:sqlserver://YourServerName:1433;DatabaseName=YourDatabaseName</dburl>
+
<dburl>jdbc:microsoft:sqlserver://YourServerName:1433;DatabaseName=YourDatabaseName;SelectMethod=Cursor;</dburl>
?
+++++++++++++++++++++
+
+ Note the __SelectMethod=Cursor;__ addition into the JDBC URL. This prevents
errors when using database actions due to auto-commit defaulting to false.
Using <auto-commit>true</auto-commit> does not make any difference to the old
db actions. If you do not do this you will get an exception saying something
like:
+ {{{
+ org.apache.cocoon.ProcessingException: Could not prepare statement :position
= 0:
+ java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start
a cloned connection while in manual transaction mode.
+ }}}
+
+ Please see
[http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b313181] for more
details...
+
