[jboss-user] [jBPM] - Re: Where are the sql statements to create tables in database for jbpm 5.4

[roxy1987]

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

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
There are table entity classes. You can check out the persistence.xml file for the classes and their path.

jbpm-installer\db\task-persistence..... &
jbpm-installer\db\jbpm-persistence....

Regards.

--------------------------------------------------------------

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

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

[mike just]

mike just [https://community.jboss.org/people/ohmygod] created the discussion

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
Thanks, roxy. But I only find ProcessInstanceInfo table in ProcessInstanceInfo.hbm.xml. How about other tables?

And my concern is when and how these tables are created. I think they need to be created before the runtime, right?
--------------------------------------------------------------

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

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

[mike just]

mike just [https://community.jboss.org/people/ohmygod] created the discussion

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
To make the problem clearer, I have a project (using jboss 7.1.1) which was using jbpm 3 version. Now I am trying to upgrade jbpm 3 to jbpm 5.4 in my project, instead of using the whole jbpm 5.4 installer project.

My question is how to do this. My first confusion is where the initial sql scripts are to create associated tables in my database (I am using MySQL).
--------------------------------------------------------------

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

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

[roxy1987]

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

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
Like I said. The tables are generated with JPA Entities. If you checkout the persistence file, you can get the class names. Eg. Table SESSIONINFO entity class is in
drools-persistence-jpa-5.x.x.jar. These are classes with @ Entity annotation and are created when you deploy jpbm-console-server war.

For help on migration, checkout this link. http://planet.jboss.org/post/migrating_to_jbpm5

Regards.

--------------------------------------------------------------

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

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

[mike just]

mike just [https://community.jboss.org/people/ohmygod] created the discussion

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
Thanks so much roxy. It is clearer to me now.

Besides deploying jbpm-gwt-console-server-5.4.0.Final-EE6.war (I only found this similar war with your mentioned jpbm-console-server war in jbpm 5.4 package), what else needs to be copied to my jboss project? for example, associated jar files or xml files?
--------------------------------------------------------------

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

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

[roxy1987]

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

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
Hi Mike,

I dont understand what you mean by jboss project here. If you need help in creating a web application using jbpm5 then this may get you started. https://community.jboss.org/people/roxy1987/blog/2013/01/22/jbpm5-web-application-example https://community.jboss.org/people/roxy1987/blog/2013/01/22/jbpm5-web-application-example. But its in WebSphere server. So you will need to change a few config. Good luck.

Regards.

--------------------------------------------------------------

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

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

[mike just]

mike just [https://community.jboss.org/people/ohmygod] created the discussion

"Re: Where are the sql statements to create tables in database for jbpm 5.4"

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

--------------------------------------------------------------
Yes, I mean creating the jboss web application using jbpm5. Thanks Shobhit. I will take a look and have a try.
--------------------------------------------------------------

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

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