[jboss-user] [JBoss jBPM] - Re: Problems with jbpm 3.3.1 GA and JBoss AS 5.0.0 GA

[hkapoor@ciber.com]

Upon further investigation I found that JBPM uses following 2 queries


       <jaas:module-option name='principalsQuery'> 
SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=? </jaas:module-option>****<jaas:module-option name='rolesQuery'> 
              SELECT g.NAME_ ,&apos;Roles&apos; FROM JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g 
              WHERE g.TYPE_=&apos;security-role&apos; AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_=? </jaas:module-option>
      </jaas:login-module>
The first query return result if any of admin, user, manager or shipper is used, however the second query does not return any record as tables JBPM_ID_MEMBERSHIP and JBPM_ID_GROUP are empty.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4206892#4206892

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4206892