[jboss-user] [jBPM] - Re: Oracle schema for jbpm 5.4

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: Oracle schema for jbpm 5.4"

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

--------------------------------------------------------------
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
[https://community.jboss.org/message/780027#780027]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20121205/5c85788c/attachment-0001.html