7 Replies Latest reply on Jun 10, 2008 5:06 AM by Kevin Conner

    jbpm-console configuation for JBoss AS using 4.3.GA

    Sidney Zurch Novice

      The jBPM console is very neat3, but it won't work "out of the box" if you try to deploy JBossESB 4.3.GA to your existing JBoss AS.

      Much has been written about this, but here's a solution in a few simple steps:

      1) Download the jbpm-jpdl-3.2.2 release

      2) Copy the two files, jbpmDB.properties and jbpmDB.script to the JBoss AS data/hypersonic directory. The source directory is jbpm-jpdl-3.2.2/server/server/jbpm/data/hypersonic

      3) Add the much-discussed security policy to the JBoss AS login-config.xml.

       <application-policy name = "jbpm">
       <authentication>
       <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule"
       flag="required">
       <module-option name="dsJndiName">java:/JbpmDS</module-option>
       <module-option name="principalsQuery">
       SELECT PASSWORD_ FROM JBPM_ID_USER WHERE NAME_=?
       </module-option>
       <module-option name="rolesQuery">
       SELECT g.NAME_ ,'Roles'
       FROM JBPM_ID_USER u,
       JBPM_ID_MEMBERSHIP m,
       JBPM_ID_GROUP g
       WHERE g.TYPE_='security-role'
       AND m.GROUP_ = g.ID_
       AND m.USER_ = u.ID_
       AND u.NAME_=?
       </module-option>
       </login-module>
       </authentication>
       </application-policy>