cocoon-docs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stev...@outerthought.org
Subject [WIKI-UPDATE] MsSQL Tue Feb 4 01:00:03 2003
Date Tue, 04 Feb 2003 00:00:03 GMT
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...
+ 



Mime
View raw message