The JDBCRealm does two things: 1) Authenticates the user (by checking password) 2) Authorizes the user (by checking roles)
The logs would seem to imply the JDBC driver is blowing up creating the prepared statement in the second step (ie reading from the roles table).
I think Tim is right - he usually is - that there is a config problem with the db or the connection to the db.
A quick google later: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B313181
HTH,
Jon
Ostad, James wrote:
The line above the line you mentioned in the error log indicates that the connection was established at one point:
2003-11-26 11:53:19 JDBCRealm[localhost]: Username admin successfully authenticated 2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing authentication
So, I don't think that the parameters are wrong, neither the database
setup. The web application functions with form base authentication
without usage of realm.
It is my next step to implement the realm, which I having problem.
but, I will double check my settings and configuration to make sure that I didn't miss anything.
thanks,
James
-----Original Message----- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:00 PM To: Tomcat Users List Subject: Re: JDBCRealm problem
The problem is this:
2003-11-26 11:53:19 JDBCRealm[localhost]: Exception performing
authentication
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't
start a cloned connection while in manual transaction mode.
Since I don't use SQL server and Java, I can't be of more help, but my guess is - Database setup - Driver parameter missing
-Tim
Ostad, James wrote:
Hi everyone, Hope everyone will have a great TG Day.
Problem: I am not able to login successfully. It keeps failing.
Structure: using JDBCRealm + form authentication
database property: match exactly as explained in tomcat documentation for setting up JDBCRealm
I am including three things:
1-server.xml part for realm setup 2-web.xml of the web apps 3-errorlog file is the error log I get when I attempt to use
jdbcrealm.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
<---In (14)
Out---> (3)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
