Hi
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>
</login-module>
</application-policy>
I have the following in the jboss.xml of the app:
<security-domain>java:/jaas/MFOracle</security-domain>
<enterprise-beans>
<ejb-name>ogc</ejb-name>
<jndi-name>ogc</jndi-name>
true
</enterprise-beans>
What am I doing wrong??
Thanks!!