Exporting DDL for production

[ossa]

Hi Guys,

I had set

<property name="hibernate.hbm2ddl.auto" value="update" />

for my development environment. All the tables, constraints, indexes and sequence are auto-created by hibernate.

I am now preparing for production and I need to remove this auto function.

May I know if there is any way to generate the SQL scripts that created all the database objects needed by JBPM. I am using Oracle 10g as my database.

Btw, is there any way, I can tell Hibernate to use different sequence number for different JBPM tables? Currently all tables are using one sequence called HIBERNATE_SEQUENCE

thanks

[calca]

Hey, this may help you

http://community.jboss.org/message/638912

[ossa]

awsome, that is what i m looking for! i shall try it tomorrow when i m in the office.

[swiderski.maciej]

Additionally you could you JBoss Tools to generate DDL, for more information please take a look at: http://docs.jboss.org/tools/3.2.0.GA/en/hibernatetools/html/plugins.html#generate_ddl_entities_with_hibernate

[ossa]

The Java alternatively way if anyone else is interested. 

import org.hibernate.cfg.Configuration;

import org.hibernate.ejb.Ejb3Configuration;

import org.hibernate.tool.hbm2ddl.SchemaExport;

......

Configuration cfg = new Ejb3Configuration().configure("org.jbpm.task",null).getHibernateConfiguration();

SchemaExport export = new SchemaExport(cfg);

export.setOutputFile("org.jbpm.task.sql");

export.setDelimiter(";");

export.setFormat(false);

export.execute(true, false, false, false);