TomCat 4.0.2 + JDBC MSSQL2000 drivers + BASE auth = exception ?

[Roman Pokrovskij <Ro...@stinklas.lt>]

Hello ALL

Configuration:
Win2000, JDK 1.3.1_02, MS SQL Server 2000
Tomcat configured to use BASE authorization...

All works properly with TC 4.0 (which comes with Borland IDE).

TC 4.0.2 asks (three times)  for password, but after that write into the log
file this:
-------------------------
2002-02-20 01:43:32 JDBCRealm[Standalone]: Username manager successfully
authenticated
2002-02-20 01:43:32 JDBCRealm[Standalone]: Exception performing
authentication
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Can't start a
cloned connection while in manual transaction mode.
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)
        at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown
Source)
-------------------------
Then show the "access is forbidden" screen :-(

P.S. For all TC versions I have used this connection string in realm
definition:
connectionURL="jdbc:microsoft:sqlserver://testserver:1433;DatabaseName=VMSDV
;SelectMethod=cursor"

I guess that TC4.0.2 doesn't understand last part : "SelectMethod=cursor".
But how it can be possible ?




--
To unsubscribe:   <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>