How to config jbpm-console for mysql and jboss correct!!!

[inxaoc]

If you download starter-kit-3.2.2 you will get jbpm-console.war example in deploy folder. it works good if you run it as standalone app with start.bat but if you will try to migrate this app to real jboss server and try use Mysql (instead of Hipersonik) it will work awry! I've made this instructions (http://wiki.jboss.org/wiki/Wiki.jsp?page=JbpmOnTomcat)/
In this article is described how to use Tomcat:

3.1 Create a file jbpm-console.xml in /$CATALINA_HOME/conf/Catalina/localhost similar to

<Context>
<Realm className="org.apache.catalina.realm.JDBCRealm"
 driverName="com.mysql.jdbc.Driver"
 connectionURL="jdbc:mysql://localhost:3306/jbpm32"
 connectionName="jbossjbpm"
 connectionPassword="jbossjbpm"
 userTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
 userNameCol="g.TYPE_ = 'security-role' AND m.GROUP_ = g.ID_ AND m.USER_ = u.ID_ AND u.NAME_"
 userCredCol="DISTINCT u.PASSWORD_"
 userRoleTable="JBPM_ID_USER u, JBPM_ID_MEMBERSHIP m, JBPM_ID_GROUP g"
 roleNameCol="g.NAME_" />
</Context>

But how to config security for jboss (I should config it in login-config.xml?) and what query I should use to get different meanings for authorization, like in the mentioned piece of code?
Does anybody have working example of jbpm-console.war?????

Please share your experience in using mysql and jboss for jbpm!

[kukeltje]

you want it to run on jboss but use the JbpmOnTomcat wiki page. That'll never work. Try the correct page http://wiki.jboss.org/wiki/Wiki.jsp?page=DeployJbpm3.2WebAppUnderJBoss4.2.x

[inxaoc]

Advise me how to find right articles and right links? Why not working articles are located on jboss wiki page?
I've made what is described in the mentioned article above but again I've got exceptions about faces and jsf. I don't know jsf, but I think it's terrible lib. In each my experiments with jbpm examples I have exceptions which are connected with JSF!
Is it possible that the minimal difference between versions can invoke new problems (like this 3.2.2 and 3.2.GA)? What's better 3.2.2 or 3.2.GA? Why do the jboss/examples/extenders have such arhitecture in which there are so hard dependencies that I have to change different parts of app each time!

[mputz]

Hi,

the link Ronald provided contains a section 'Additional Notes for jBPM 3.2.1/jBPM 3.2.2' with two possible ways to get the right libraries in the web-console on JBoss 4.2.x:

* checkout the sources from cvs and use the provided ant task OR
* manually include the listed jars in the web application


Either one of the two approaches should work. Which one did you try?

[inxaoc]

Thank you for reply. I've tried with 3.2.GA. it's work well. But where can I find sources of jbpm-console (jbpm-enterprise) application? Is it in examples/websale folder of starter-suite only? When can I get build file for creating jbpm-enterprise.ear independently?

[kukeltje]

in cvs