Hi everyone,
I'm trying to use JDBCRealm for authetication and I'm having some problems.
The trace of the session state that authetication was successful, yet, the
system keeps asking for username and password and finally fails. Any idea
what could be wrong?
Here is the server.xml setting: (I checked the database connection and it
works fine with that driver and URL)
<RequestInterceptor
className="org.apache.tomcat.request.JDBCRealm"
debug="99"
driverName="com.thinweb.tds.Driver"
connectionURL="jdbc:twtds:sqlserver://intrigue/PPSDB"
connectionName="ppsdb"
connectionPassword="ppsdb"
userTable="account"
userNameCol="userid"
userCredCol="user_pass"
userRoleTable="user_roles"
roleNameCol="role_name" />
The trace in the tomcat windows is:
2001-08-06 10:37:24 - ContextManager: JDBCRealm: The database connection is null
or was found to be closed. Trying to re-open it.
2001-08-06 10:37:24 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT
user_pass FROM account WHERE userid = ?
2001-08-06 10:37:24 - ContextManager: JDBCRealm: Authentication successful for u
ser j2ee
2001-08-06 10:37:24 - ContextManager: JDBCRealm: Auth ok, user=j2ee
and yet, the system keeps asking me to login!
Help greatly appreciated,
Francois Bronsard
