Return-Path: 
 <cocoon-docs-return-418-apmail-xml-cocoon-docs-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-docs-archive@xml.apache.org
Received: (qmail 34263 invoked by uid 500); 3 Feb 2003 23:59:57 -0000
Mailing-List: contact cocoon-docs-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-docs-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-docs-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-docs@xml.apache.org>
Reply-To: cocoon-docs@xml.apache.org
Delivered-To: mailing list cocoon-docs@xml.apache.org
Received: (qmail 34253 invoked from network); 3 Feb 2003 23:59:56 -0000
Received: from otsrv1.iic.rug.ac.be (157.193.121.51)
  by daedalus.apache.org with SMTP; 3 Feb 2003 23:59:56 -0000
Received: from otsrv1.iic.rug.ac.be (localhost [127.0.0.1])
	by otsrv1.iic.rug.ac.be (8.11.6/8.11.6) with ESMTP id h14003t31764
	for <cocoon-docs@xml.apache.org>; Tue, 4 Feb 2003 01:00:03 +0100
Date: Tue, 4 Feb 2003 01:00:03 +0100
Message-Id: <200302040000.h14003t31764@otsrv1.iic.rug.ac.be>
From: stevenn@outerthought.org
To: cocoon-docs@xml.apache.org
Subject: [WIKI-UPDATE] MsSQL Tue Feb  4 01:00:03 2003
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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...
+