You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by dl...@apache.org on 2002/03/29 08:15:52 UTC
cvs commit: jakarta-turbine-torque/xdocs mssql-howto.xml
dlr 02/03/28 23:15:51
Modified: xdocs mssql-howto.xml
Log:
Added a note about the SelectMethod=cursor JDBC connection string
parameter for the com.microsoft.jdbc.sqlserver.SQLServerDriver driver
suggested by Will Glass-Husain <wg...@forio.com>.
Revision Changes Path
1.3 +16 -2 jakarta-turbine-torque/xdocs/mssql-howto.xml
Index: mssql-howto.xml
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/xdocs/mssql-howto.xml,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -u -r1.2 -r1.3
--- mssql-howto.xml 7 Dec 2001 07:55:52 -0000 1.2
+++ mssql-howto.xml 29 Mar 2002 07:15:51 -0000 1.3
@@ -76,7 +76,7 @@
]]></source>
<p>
-And set the JDBC connection information;
+And set the JDBC connection information:
</p>
<source><![CDATA[
@@ -88,7 +88,21 @@
]]></source>
<p>
-If you are using the JDBC-ODBC bridge driver then;
+If you are using the Microsoft driver
+(i.e. <code>com.microsoft.jdbc.sqlserver.SQLServerDriver</code>),
+you'll need to use the <code>SelectMethod=cursor</code> parameter in
+the JDBC connection string (as outlined by <a
+href="http://forum.java.sun.com/thread.jsp?forum=48&thread=184797">this
+JDC thread</a>). Your <code>databaseUrl</code> would look something
+like the following:
+</p>
+
+<source><![CDATA[
+jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;SelectMethod=cursor
+]]></source>
+
+<p>
+If you are using the JDBC-ODBC bridge driver:
</p>
<source><![CDATA[
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>