Example usage for org.hibernate.tool.hbm2ddl SchemaExport setDelimiter

Introduction

In this page you can find the example usage for org.hibernate.tool.hbm2ddl SchemaExport setDelimiter.

Prototype

public SchemaExport setDelimiter(String delimiter) 

Source Link

Document

Set the end of statement delimiter

Usage

From source file:at.stefanproell.PersistentIdentifierMockup.HibernateSchemaGeneratorPID.java

License:Apache License

public static void main(String[] args) {

    String outputFilePath = "PersistentIdentification/additional_configuration/PID-Hibernate-schema.sql";

    Configuration config = new Configuration();
    config.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
    config.addAnnotatedClass(PersistentIdentifier.class);
    config.addAnnotatedClass(Organization.class);
    SchemaExport export = new EnversSchemaGenerator(config).export().setOutputFile(outputFilePath);
    export.setDelimiter(";");
    export.execute(true, false, false, false);

    // Update Schema
    //updateSchema(config);
}

---

From source file:be.fedict.eid.applet.maven.sql.ddl.SQLDDLMojo.java

License:Open Source License

@Override
public void execute() throws MojoExecutionException, MojoFailureException {
    getLog().info("SQL DDL script generator");

    File outputFile = new File(this.outputDirectory, this.outputName);
    getLog().info("Output SQL DDL script file: " + outputFile.getAbsolutePath());

    this.outputDirectory.mkdirs();
    try {/*from  w ww  .  j a va  2s.  com*/
        outputFile.createNewFile();
    } catch (IOException e) {
        throw new MojoExecutionException("I/O error.", e);
    }

    for (ArtifactItem artifactItem : this.artifactItems) {
        getLog().info("artifact: " + artifactItem.getGroupId() + ":" + artifactItem.getArtifactId());
        List<Dependency> dependencies = this.project.getDependencies();
        String version = null;
        for (Dependency dependency : dependencies) {
            if (StringUtils.equals(dependency.getArtifactId(), artifactItem.getArtifactId())
                    && StringUtils.equals(dependency.getGroupId(), artifactItem.getGroupId())) {
                version = dependency.getVersion();
                break;
            }
        }
        getLog().info("artifact version: " + version);
        VersionRange versionRange = VersionRange.createFromVersion(version);
        Artifact artifact = this.artifactFactory.createDependencyArtifact(artifactItem.getGroupId(),
                artifactItem.getArtifactId(), versionRange, "jar", null, Artifact.SCOPE_COMPILE);
        try {
            this.resolver.resolve(artifact, this.remoteRepos, this.local);
        } catch (ArtifactResolutionException e) {
            throw new MojoExecutionException("Unable to resolve artifact.", e);
        } catch (ArtifactNotFoundException e) {
            throw new MojoExecutionException("Unable to find artifact.", e);
        }
        getLog().info("artifact file: " + artifact.getFile().getAbsolutePath());
        getLog().info("hibernate dialect: " + this.hibernateDialect);

        URL artifactUrl;
        try {
            artifactUrl = artifact.getFile().toURI().toURL();
        } catch (MalformedURLException e) {
            throw new MojoExecutionException("URL error.", e);
        }

        URLClassLoader classLoader = new URLClassLoader(new URL[] { artifactUrl },
                this.getClass().getClassLoader());
        Thread.currentThread().setContextClassLoader(classLoader);

        AnnotationDB annotationDb = new AnnotationDB();
        try {
            annotationDb.scanArchives(artifactUrl);
        } catch (IOException e) {
            throw new MojoExecutionException("I/O error.", e);
        }
        Set<String> classNames = annotationDb.getAnnotationIndex().get(Entity.class.getName());
        getLog().info("# JPA entity classes: " + classNames.size());

        AnnotationConfiguration configuration = new AnnotationConfiguration();

        configuration.setProperty("hibernate.dialect", this.hibernateDialect);
        Dialect dialect = Dialect.getDialect(configuration.getProperties());
        getLog().info("dialect: " + dialect.toString());

        for (String className : classNames) {
            getLog().info("JPA entity: " + className);
            Class<?> entityClass;
            try {
                entityClass = classLoader.loadClass(className);
                getLog().info("entity class loader: " + entityClass.getClassLoader());
            } catch (ClassNotFoundException e) {
                throw new MojoExecutionException("class not found.", e);
            }
            configuration.addAnnotatedClass(entityClass);
        }

        SchemaExport schemaExport = new SchemaExport(configuration);
        schemaExport.setFormat(true);
        schemaExport.setHaltOnError(true);
        schemaExport.setOutputFile(outputFile.getAbsolutePath());
        schemaExport.setDelimiter(";");

        try {
            getLog().info("SQL DDL script: " + IOUtil.toString(new FileInputStream(outputFile)));
        } catch (FileNotFoundException e) {
            throw new MojoExecutionException("file not found.", e);
        } catch (IOException e) {
            throw new MojoExecutionException("I/O error.", e);
        }

        // operate
        schemaExport.execute(true, false, false, true);
        List<Exception> exceptions = schemaExport.getExceptions();
        for (Exception exception : exceptions) {
            getLog().error("exception: " + exception.getMessage());
        }
    }
}

---

From source file:be.fedict.eid.pkira.blm.hibernateutil.SchemaGenerator.java

License:Open Source License

/**
 * Method that actually creates the file.
 * /*w  w w . ja v a 2s .c  om*/
 * @param dbDialect
 *            to use
 */
private void generate(Dialect dialect) {
    new java.io.File(workingDir + "/schema").mkdirs();

    cfg.setProperty("hibernate.dialect", dialect.getDialectClass());

    SchemaExport export = new SchemaExport(cfg);
    export.setDelimiter(";");
    export.setOutputFile(workingDir + "/schema/ddl_" + dialect.name().toLowerCase() + ".sql");
    export.execute(true, false, false, false);
}

---

From source file:br.com.machina.verbum.Main.java

License:Apache License

private static void generateTables() {

    AnnotationConfiguration configuration = new AnnotationConfiguration();
    configuration.configure();/*  w  w  w  .j  a  v a2  s . c  o  m*/

    SchemaExport export = new SchemaExport(configuration);
    export.setDelimiter(";");
    export.setOutputFile("tables.sql");
    export.create(true, true);
    System.out.println("Ok!");

}

---

From source file:ca.myewb.build.CreateDb.java

License:Open Source License

private static void createDb(String postfix) {
    try {/*from www.jav  a2 s .c  o m*/
        System.out.println("Creating fresh database");

        Configuration config = HibernateUtil.getConfiguration(postfix);

        // Set up the schema exporter utility
        SchemaExport sch = new SchemaExport(config);
        sch = sch.setDelimiter(";");

        // Drop and re-create the database
        sch.drop(false, true);
        sch.create(false, true);
    } catch (Exception e) {
        System.err.print("Exception: " + e);
        e.printStackTrace();
    }
}

---

From source file:com.ah.util.HibernateUtil.java

public static void main(String[] args) {
    init(false);//from   www  . ja v  a  2s  .c o m
    System.out.println("Entered HibernateUtil.main");
    System.out.println("# arguments: " + Arrays.asList(args));
    System.out.println("Getting configuration.");

    if ("create".equals(args[0])) {
        if (args.length >= 2) {
            String newUrl = "jdbc:postgresql://localhost/" + args[1];
            configuration.setProperty("hibernate.connection.url", newUrl);

            if (args.length >= 3) {
                try {
                    int i = Integer.parseInt(args[2]);

                    if ((1 == i) && (BeOperateHMCentOSImpl.isExistHomeDomain())) {
                        System.out.println("have tables! need not recreate");

                        return;
                    }
                } catch (Exception ex) {
                    System.out.println(ex);
                }
            }
        }

        SchemaExport schemaExport = new SchemaExport(configuration);

        System.out.println("Creating schema ...");
        schemaExport.create(true, true);
        //   BeSqlProcedure.insertSqlProcedure();
        DBFunction.createHex2Int();
        DBFunction.createDBRollUp();
        DBFunction.createRepoRollUp();
        System.out.println("Create schema finished.");
    } else if ("export".equals(args[0])) {
        SchemaExport schemaExport = new SchemaExport(configuration);

        schemaExport.setOutputFile("schema.ddl");
        schemaExport.setDelimiter(";");
        System.out.println("Exporting schema ...");
        schemaExport.create(true, false);
        System.out.println("Export finished.");
    } else if ("drop".equals(args[0])) {
        SchemaExport schemaExport = new SchemaExport(configuration);

        System.out.println("Dropping schema ...");
        schemaExport.drop(true, true);
        System.out.println("Drop schema finished.");
    } else if ("reset".equals(args[0])) {
        //java HibernateUtil reset jdbc:postgresql://ip_address/db_name
        if (args.length >= 2) {
            configuration.setProperty("hibernate.connection.url", args[1]);
        }
        SchemaExport schemaExport = new SchemaExport(configuration);
        schemaExport.create(true, true);
        DBFunction.createHex2Int();
        DBFunction.createDBRollUp();
        DBFunction.createRepoRollUp();
        System.out.println("execute reset finished.");
    }

    close();
}

---

From source file:com.amalto.core.storage.hibernate.HibernateStorage.java

License:Open Source License

private void traceDDL() {
    try {/*from ww  w . ja  v a2 s  .c  om*/
        if (configuration == null) {
            throw new IllegalStateException("Expect a Hibernate configuration to be set."); //$NON-NLS-1$
        }
        String jbossServerTempDir = System.getProperty("java.io.tmpdir"); //$NON-NLS-1$
        RDBMSDataSource.DataSourceDialect dialectType = dataSource.getDialectName();
        SchemaExport export = new SchemaExport(configuration);
        export.setFormat(false);
        String filename = jbossServerTempDir + File.separator + storageName + "_" + storageType + "_" //$NON-NLS-1$//$NON-NLS-2$
                + dialectType + ".ddl"; //$NON-NLS-1$
        export.setOutputFile(filename);
        export.setDelimiter(";"); //$NON-NLS-1$
        export.execute(false, false, false, true);
        if (export.getExceptions().size() > 0) {
            for (int i = 0; i < export.getExceptions().size(); i++) {
                LOGGER.error("Error occurred while producing ddl.", //$NON-NLS-1$
                        (Exception) export.getExceptions().get(i));
            }
        }
        LOGGER.info("DDL exported to file '" + filename + "'."); //$NON-NLS-1$ //$NON-NLS-2$
    } catch (Exception e) {
        LOGGER.error("Error occurred while producing ddl.", e); //$NON-NLS-1$
    }
}

---

From source file:com.comcast.cats.recorder.persistence.SqlTableCreator.java

License:Open Source License

/**
 * Method that actually creates the file.
 * /*from   ww  w . jav  a2 s .com*/
 * @param dbDialect
 *            to use
 */
private void generate(Dialect dialect) {
    cfg.setProperty("hibernate.dialect", dialect.getDialectClass());

    SchemaExport export = new SchemaExport(cfg);
    export.setDelimiter(";");
    export.setOutputFile("ddl_" + dialect.name().toLowerCase() + ".sql");
    export.execute(true, false, false, false);
}

---

From source file:com.evolveum.midpoint.repo.sql.SchemaTest.java

License:Apache License

private void createSQLSchema(String fileName, String dialect) {
    File file = new File(fileName);
    if (file.exists()) {
        file.delete();//from www .  j  a  v a  2 s .co m
    }

    MetadataSources metadata = new MetadataSources(new StandardServiceRegistryBuilder()
            .applySetting("hibernate.implicit_naming_strategy", new MidPointImplicitNamingStrategy())
            .applySetting("hibernate.physical_naming_strategy", new MidPointPhysicalNamingStrategy())
            .applySetting("hibernate.dialect", dialect).build());

    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.container", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.any", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.embedded", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.enums", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.id", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.other", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.type", metadata);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.audit", metadata);

    metadata.addPackage("com.evolveum.midpoint.repo.sql.type");

    SchemaExport export = new SchemaExport();
    export.setOutputFile(fileName);
    export.setDelimiter(";");
    //        export.setFormat(true);
    export.execute(EnumSet.of(TargetType.SCRIPT), SchemaExport.Action.CREATE, metadata.buildMetadata());
}

---

From source file:com.evolveum.midpoint.repo.sql.SpringApplicationContextTest.java

License:Apache License

private void createSQLSchema(String fileName, String dialect) throws Exception {
    org.hibernate.cfg.Configuration configuration = new Configuration();
    configuration.setNamingStrategy(new MidPointNamingStrategy());
    configuration.setProperties(sessionFactory.getHibernateProperties());
    sessionFactory.getHibernateProperties().setProperty("hibernate.dialect", dialect);

    System.out.println("Dialect: " + sessionFactory.getHibernateProperties().getProperty("hibernate.dialect"));

    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.container", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.any", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.embedded", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.enums", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.id", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.other", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.common.type", configuration);
    addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.audit", configuration);
    //        addAnnotatedClasses("com.evolveum.midpoint.repo.sql.data.poc", configuration);

    configuration.addPackage("com.evolveum.midpoint.repo.sql.type");

    SchemaExport export = new SchemaExport(configuration);
    export.setOutputFile(fileName);/* w ww  .ja  v  a  2s .co m*/
    export.setDelimiter(";");
    export.execute(true, false, false, true);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »