[jboss-user] [jBPM] - Re: how to install the jbpm5 to work on mysql database

[Erik Vande Velde]

Erik Vande Velde [https://community.jboss.org/people/erikv] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/726582#726582

--------------------------------------------------------------
How come no one mentions the jBPM-ds.xml file in this discussion? Don't we have to change this one too, or is it unused somehow ?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/726582#726582]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[nirav2003]

nirav2003 [https://community.jboss.org/people/nirav2003] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/727068#727068

--------------------------------------------------------------
If you are using jBPM-ds.xml to create base structure. Yes you need to change. You may skip it by creating base strucrute using provided SQL scripts.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/727068#727068]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Erik Vande Velde]

Erik Vande Velde [https://community.jboss.org/people/erikv] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/727110#727110

--------------------------------------------------------------
The main problem for me is that my installer zip file, jbpm-5.2.0.Final-installer-full.zip, doesn't contain any sql scripts for mysql.
The documentation in this thread was insufficient to get that version working with mysql. I found out that in the included jboss 7 you need to install the mysql driver as described in http://planet.jboss.org/view/post.seam?post=how_to_create_and_manage_datasources_in_as7 http://planet.jboss.org/view/post.seam?post=how_to_create_and_manage_datasources_in_as7. In jboss as 7 apparently the jbpm datasource is defined in standalone.xml, and I'm about sure that a port to mysql cannot be achieved without changing that file too.
Puzzling all pieces together I currently have a 5.2.0 working on mysql, the only remaining problem is that in the demo scenario the workflow diagram always remains in the start state, even when krisv did a self evaluation.
My gut feeling is that 5.2 is not production quality yet today, I'll create a separate post to see what the rest of the world thinks about this ...
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/727110#727110]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Lisa DeSouza]

Lisa DeSouza [https://community.jboss.org/people/lisadesouza89] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/793663#793663

--------------------------------------------------------------
hey Erik,
I'm in the same boat as you, unable to find any database scripts for jBPM in MySQL. Have you had any luck progressing??
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/793663#793663]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Erik Vande Velde]

Erik Vande Velde [https://community.jboss.org/people/erikv] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/793787#793787

--------------------------------------------------------------
Hello Lisa,

Judging from the message I posted some time ago it has worked at a certain moment in time, but it was unclear to me how the sample application was supposed to work exactly.
As we're still not sure we will need (J)BPM in our project, we're essentially patiently waiting for a book on JBPM 5.
Mauricio Salatino announced such a book long time ago, but I think it hasn't hit the market yet, so we changed our attention to other technologies lately.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/793787#793787]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Pankaj M]

Pankaj M [https://community.jboss.org/people/pankajm] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/739920#739920

--------------------------------------------------------------
Nirav, I am trying to install jbpm-5.3, I have followed steps which need to be change but i can't able to see the database table structure in mysql database.
Regarding "SQL scripts" mentioned by you, i can't able to find it in jbpm-5.3.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/739920#739920]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Nicholas Eric]

Nicholas Eric [https://community.jboss.org/people/92loveinlife] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/755980#755980

--------------------------------------------------------------
Hi *nirav2003*, I am configuring jbpm 5.1 on jboss 5.1 with mysql 5.1, I have done it according to your description, can you tell me how to prove the configuration is successful.
See the database structure in mysql database??
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/755980#755980]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[martinchin2289]

martinchin2289 [https://community.jboss.org/people/martinchin2289] created the discussion

"Re: how to install the jbpm5 to work on mysql database"

To view the discussion, visit: https://community.jboss.org/message/757329#757329

--------------------------------------------------------------
I was able to configure it by adding a module with the mysql connector to jboss as7.

It may be the case if you see a message like this in the server log:
+*New missing/unsatisfied dependencies:       service jboss.jdbc-driver.mysql*+

Check on the following link :
https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/ https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/757329#757329]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]