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

[bu...@apache.org]

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

           Summary: JDBCRealm and MS SQLServer
           Product: Tomcat 4
           Version: 4.0.4 Final
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Catalina
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: stefan.rutenkolk@fiprox.com


Hy Folks,

I'm working on a project with Oracle as well MS-SQLServer. My webcontainer is 
tomcat 4.0.4.
Using the RDBMSRealm via Oracle-JDBC-Driver with the oracle database
is no problem.
But if i switch to RDBMSRealm with the "Microsoft SQL Server 2000 Driver for
JDBC" there is no connect via Realm possible.

The error is as follows:
java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]
can't open clone connection because you are in implicit Transactionmode.


I guess the reason is in the source tomcat4.0.4-class package
"org.apache.catalina.realm.JNDIRealm" in line 549 where the autocommit is set 
to FALSE. 
There are two security-check prepeared-SELECT-statements with no "stmt.close
();" in between. (normally OK...)

The first prepeared-SELECT-Statement works, the second doesn't.
The SQLServer is in implicit Transactionmode and in that way (with prepared-
Statements) it can't work, 
because there is an explicit commit (autocommit(true)) or a stmt.close() 
necessary. If i try the same
with NOTprepared Statements it works also.


thank you

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