You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2003/04/22 21:32:25 UTC
DO NOT REPLY [Bug 19227] New: - NullPointerException using MS SQL Server driver with JDBCRealm

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=19227>.
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=19227

NullPointerException using MS SQL Server driver with JDBCRealm

           Summary: NullPointerException using MS SQL Server driver with
                    JDBCRealm
           Product: Tomcat 4
           Version: 4.0.6 Final
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Catalina
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: rduncan@bds.com


In attempting to configure the JDBCRealm for use with MS supplied SQL Server 
driver, the JDBCRealm gets a NullPointerException. From the server.xml:

      <Realm className="org.apache.catalina.realm.JDBCRealm"
             connectionName="user"
             connectionPassword="password"
             
connectionURL="jdbc:microsoft:sqlserver://parkcity:1433;SelectMethod=cursor"
             debug="99"
             driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
             userTable="Users"
             userRoleTable="UserRoles"
             userRoleNameCol="rolename"
             userNameCol="username"
             userCredCol="password"
             />

>From the Log File:

2003-04-22 14:55:57 JDBCRealm[Standalone]: Username rduncan successfully 
authenticated
2003-04-22 14:55:57 HttpProcessor[8080][3] process.invoke
java.lang.NullPointerException
	at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:410)
	at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326)
	at org.apache.catalina.authenticator.BasicAuthenticator.authenticate
(BasicAuthenticator.java:161)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
   .
   .
   .

The user's credentials (pwd) are successfully authenticated. The 
NullPointerException happens as the method attempts to collect the user's roles.

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org