0 Replies Latest reply on May 12, 2004 5:08 AM by aalberts

    JBoss 3.2.3 (Tomcat Integrated) principal=null error

    aalberts Newbie


      I am getting the following error once logged and the app tries to use the EJB:

      EJBException:; nested exception is: javax.ejb.EJBException: checkSecurityAssociation; CausedByException is: Authentication exception, principal=null

      In the login-config.xml, I defined the following application security policy:

      <application-policy name="MFOracle">

      <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
      <module-option name="dsJndiName">java:/RUM</module-option>
      <module-option name="principalsQuery">select a.password, a.guid from ADM.APPUSERS a, ADM.APPUSERSTATUS b where a.userid = ? and b.guid = a.guid and b.user_status_code = 'ACTIVE'</module-option>
      <module-option name="rolesQuery">select rolename as Roles, 'Roles' as RoleGroup from ADM.APP_ROLES where roleid in (select roleid from ADM.APPUSERROLE where guid = (select guid from ADM.APPUSERS where userid=?))</module-option>


      I have the following in the jboss.xml of the app:




      What am I doing wrong??