You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2002/08/23 13:52:17 UTC

DO NOT REPLY [Bug 11964] - JDBCRealm and MS SQLServer

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11964>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=11964

JDBCRealm and MS SQLServer

andrewconrad@iname.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID



------- Additional Comments From andrewconrad@iname.com  2002-08-23 11:52 -------
This is not a bug in Tomcat, but rather a shortcoming with the default 
parameters of the driver; they fail when autocomit is false;

change your connection url to include  SelectMethod=cursor and look in 
Microsoft's JDBC Driver Documentation for a better explanation to SelectMethod

example url: 
jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor
(note the comma after the port)

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>