-
1. Re: Where are the sql statements to create tables in database for jbpm 5.4
roxy1987 Mar 11, 2013 12:22 PM (in response to ohmygod)The tables in the database are generated with JPA Entities.
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.
-
2. Re: Where are the sql statements to create tables in database for jbpm 5.4
ohmygod Mar 11, 2013 9:37 PM (in response to roxy1987)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?
-
3. Re: Where are the sql statements to create tables in database for jbpm 5.4
ohmygod Mar 11, 2013 11:05 PM (in response to ohmygod)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).
-
4. Re: Where are the sql statements to create tables in database for jbpm 5.4
roxy1987 Mar 12, 2013 10:30 AM (in response to ohmygod)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.
-
5. Re: Where are the sql statements to create tables in database for jbpm 5.4
ohmygod Mar 12, 2013 9:36 PM (in response to roxy1987)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? (I read the 5.4 userguide, it is all about how to work with the installer itself, so I am not able to see how to deploy it to another jboss application. Please adivse. Thanks)
-
6. Re: Where are the sql statements to create tables in database for jbpm 5.4
roxy1987 Mar 13, 2013 11:30 AM (in response to ohmygod)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. But its in WebSphere server. So you will need to change a few config. Good luck.
Regards.
-
7. Re: Where are the sql statements to create tables in database for jbpm 5.4
ohmygod Mar 13, 2013 9:34 PM (in response to roxy1987)Yes, I mean creating the jboss web application using jbpm5. Thanks Shobhit. I will take a look and have a try.