How to create JBPM tables in Production and UAT databases?

[alphabetagamma]

Hi,

To my understanding, if I run Human Task Service, then the necessary tables gets created in the database. This may be ok to go with for local and dev boxes. But the table creation is restricted in test and prod boxes. In this case, how do I get the tables created? I didn't see any standard file that has all the table creation statements. Can anyone point me to it, if something like that exists. Or show me a way to achieve it. I need tables for JBPM 5.1.

Thanks,

Kiran

[alphabetagamma]

I thought I was asking a very basic question and expected a flood of responses. Could some one pull out few mins and show some direction?

I really would appreacite your help.

Thanks,

Kiran

[calca]

Hey Kiran,

AFAIK there in no script. You may be able to create it from jpa model..

Maybe this helps you

http://stackoverflow.com/questions/281890/hibernate-jpa-to-ddl-command-line-tools

Using maven: http://users.mafr.de/~matthias/articles/generating-ddl-scripts.html

Demian

[alphabetagamma]

Thanks Demien. The stackoverflow link helped.

Attached are the DDL for different databases and the quick and dirty java class used to generate the same.

Thanks,

Kiran