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 <[EMAIL PROTECTED]>. 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: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
