3 Replies Latest reply on Sep 20, 2010 8:28 AM by mwohlf

database schema recreation while creating ProcessEngine object

parvathy Sep 19, 2010 12:52 PM

Hi i saw that creating a process engine code is ProcessEngine processEngine = new Configuration().setResource("jbpm.cfg.xml").buildProcessEngine(); but when ever i run this code for my diff test case, the database schema itself will be recreated and all the data will be lost... Could anyone tell me how to create a ProcessEngine object only once for my application..so it can be used in my diff files...and this database recreation pblm will be solved...

1. Re: database schema recreation while creating ProcessEngine object

mwohlf Sep 19, 2010 1:59 PM (in response to parvathy)

check the hibernate.hbm2ddl.auto parameter in your hibernate config
Actions
2. Re: database schema recreation while creating ProcessEngine object

parvathy Sep 20, 2010 1:51 AM (in response to mwohlf)

thank a lot...i gave property name="hibernate.hbpm2ddl.auto" update earlier it was create-drop.... but i read in one site that update is not advisable in production enviornment...is it true??is there any problem if we give update for that property????
Actions
3. Re: database schema recreation while creating ProcessEngine object

mwohlf Sep 20, 2010 8:28 AM (in response to parvathy)

you are right, it is not a good idea to rely on hibernate.hbpm2ddl.auto="update" to automatically do the tricky database updates for you
see this discussion:
http://stackoverflow.com/questions/221379/hibernate-hbm2ddl-autoupdate-in-production

there are better tools for database updates:
http://www.liquibase.org/
Actions

Go to original post