Hi,
someone get to work MS SQL 2000 Server and Tomcat 4.0.1 JDBC Realm ?
by default it throw's exception for me:
2002-01-11 13:29:52 JDBCRealm[/lsdv]: 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)
at com.microsoft.jdbc.base.BaseStatement.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.getImplStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at org.apache.catalina.realm.JDBCRealm.roles(JDBCRealm.java:587)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:377)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326)
after hacking JDBCRealm a bit ... i found a solution.
it's to change ...
dbConnection.setAutoCommit(false);
to ...
dbConnection.setAutoCommit(true);
but i don't thik it's correct for other databases.
any suggestions welcomed.
Feky
