--- title: "How to use Hibernate to generate a DDL script from your Play! Framework project" date: 2014-10-15T21:41:33+00:00 author: "poornerd" tags: ["hibernate", "jpa"] canonical: https://www.poornerd.com/2014/10/15/how-to-use-hibernate-to-generate-a-ddl-script-from-your-play-framework-project/ source: Raw Markdown twin of the HTML article; content is the original source. --- [

](https://www.poornerd.com/wp-content/uploads/2014/10/Screen-Shot-2014-10-15-at-23.34.25.png)Ok, so you have been using the hibernate property name=”**hibernate.hbm2ddl.auto**” value=”**update**” to continuously update your database schema, **but now you need a complete DDL script?** Use this method from you Global Class onStart to export the DDL scripts. Just give it the package name (with path) of your Entities as well as a file name:

public void onStart(Application app) {
        exportDatabaseSchema("models", "create_tables.sql");
    }

    public void exportDatabaseSchema(String packageName, String scriptFilename) {

        final Configuration configuration = new Configuration();
        final Reflections reflections = new Reflections(packageName);
        final Set<Class<?>> classes = reflections.getTypesAnnotatedWith(Entity.class);
        // iterate all Entity classes in the package indicated by the name
        for (final Class<?> clazz : classes) {
            configuration.addAnnotatedClass(clazz);
        }
        configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.PostgreSQL9Dialect");

        SchemaExport schema = new SchemaExport(configuration);
        schema.setOutputFile(scriptFilename);
        schema.setDelimiter(";");
        schema.execute(Target.SCRIPT, SchemaExport.Type.CREATE );  // just export the create statements in the script
    }

That is it! Thanks to @MonCalamari for answering my Question on Stackoverflow here.