JBoss Community

Re: Oracle schema for jbpm 5.4

created by Maciej Swiderski in jBPM - View the full discussion

yes, it has slightly changed. In 5.4 installer script there are two new targets that allows you to generate DDL scripts from persistence.xml files:

- jbpm.schemaexport

- ht.schemaexport

 

then in installer_home/db you'll fine several persistence files important for DDL generation are:

- jbpm-persistence-JPA1.xml

- jbpm-persistence-JPA2.xml

- task-persistence-JPA1.xml

- task-persistence-JPA2.xml

 

what you need to do is to simply edit one that interesting for you and change hibernate dialect to the one that matches your data base and next run schema export ant targets and you'll get your DDL scripts in installer_home/db/export-jbpm and/or installer_home.db/export-ht

 

by default it runs on JPA2 based persistence.xml files and uses hibernate 4 to generate ddl, it can be altered by specifying system properly when executing ant -Djpa.version=JPA1

 

HTH

Reply to this message by going to Community

Start a new discussion in jBPM at Community