Example usage for org.hibernate.cfg Configuration getProperties

List of usage examples for org.hibernate.cfg Configuration getProperties

Introduction

In this page you can find the example usage for org.hibernate.cfg Configuration getProperties.

Prototype

public Properties getProperties() 

Source Link

Document

Get all properties

Usage

From source file:de.iteratec.iteraplan.db.SchemaGenerationScriptCreator.java

License:Open Source License

public void generateDatabaseSchemaScript(String sqlOutputFilename) {
    ConfigurableApplicationContext context = LocalApplicationContextUtil.getApplicationContext();

    // potential starting point for further development - make printing to console configurable
    boolean printToConsole = true;

    LOGGER.info("Running hbm2ddl schema export");

    if (StringUtils.isNotBlank(sqlOutputFilename)) {
        outputFile = sqlOutputFilename;/*from   w  w  w. jav  a  2  s.  c  o  m*/
    }

    Writer outputFileWriter = null;

    try {
        if (outputFile != null) {
            LOGGER.info("writing generated schema to file: {0}", outputFile);
            System.out.println("writing generated schema to file: " + outputFile);
            outputFileWriter = new FileWriter(outputFile);
        }

        // retrieve Hibernate configuration object from Spring context
        AnnotationSessionFactoryBean sessionFactoryBean = context.getBean(AnnotationSessionFactoryBean.class);
        Configuration hibernateCfg = sessionFactoryBean.getConfiguration();
        Dialect dialect = Dialect.getDialect(hibernateCfg.getProperties());

        // generate drop SQL statements and write to file
        String[] dropSQL = hibernateCfg.generateDropSchemaScript(dialect);
        for (int i = 0; i < dropSQL.length; i++) {
            writeStatement(printToConsole, outputFileWriter, dropSQL[i]);
        }

        // generate create table SQL statements and write to file
        String[] createSQL = hibernateCfg.generateSchemaCreationScript(dialect);
        for (int j = 0; j < createSQL.length; j++) {
            writeStatement(printToConsole, outputFileWriter, createSQL[j]);
        }

        LOGGER.info("schema export complete");

    } catch (Exception e) {
        LOGGER.error("schema export unsuccessful", e);

    } finally {
        context.close();

        try {
            if (outputFileWriter != null) {
                outputFileWriter.close();
            }
        } catch (IOException ioe) {
            LOGGER.error("Error closing output file: " + outputFile, ioe);
        }
    }
}

From source file:de.javakaffee.web.msm.serializer.hibernate.AbstractHibernateCollectionsTest.java

License:Apache License

@BeforeTest
protected void beforeTest() {
    Configuration configuration = new Configuration().addAnnotatedClass(Person.class)
            .addAnnotatedClass(Animal.class).configure();
    StandardServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
            .applySettings(configuration.getProperties()).build();
    _sessionFactory = configuration.buildSessionFactory(serviceRegistry);
}

From source file:de.metanome.backend.results_db.HibernateUtil.java

License:Apache License

protected static SessionFactory buildSessionFactory() {
    Configuration configuration = new Configuration().configure();
    ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
            .applySettings(configuration.getProperties()).build();
    return configuration.configure().buildSessionFactory(serviceRegistry);
}

From source file:de.tudarmstadt.ukp.lmf.transform.LMFDBUtils.java

License:Apache License

public static void dropTables(final DBConfig dbConfig) {
    System.out.println("DROP TABLES");
    Configuration cfg = HibernateConnect.getConfiguration(dbConfig);
    cfg.setProperty("hibernate.hbm2ddl.auto", "none");
    SessionFactory sf = cfg.buildSessionFactory(
            new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry());
    Session session = sf.openSession();//from w  ww  . ja va2  s  . c om
    Transaction tx = session.beginTransaction();
    try {
        // Create a set of all tables.
        Set<String> dropSQL = new TreeSet<String>();
        Iterator<Table> iter = cfg.getTableMappings();
        while (iter.hasNext())
            dropSQL.add("DROP TABLE " + iter.next().getName());

        // Try to delete them repeatedly until no tables are left or 
        // there have been too many repetitions.
        int remainingLoops = dropSQL.size();
        while (!dropSQL.isEmpty() && remainingLoops >= 0) {
            Iterator<String> sqlIter = dropSQL.iterator();
            while (sqlIter.hasNext()) {
                try {
                    String sql = sqlIter.next();
                    session.createSQLQuery(sql).executeUpdate();
                    sqlIter.remove();
                    System.out.println(sql);
                } catch (HibernateException e) {
                }
            }
            remainingLoops--;
        }
    } finally {
        tx.commit();
        session.disconnect();
        session.close();
    }
}

From source file:de.tudarmstadt.ukp.lmf.transform.LMFDBUtils.java

License:Apache License

public static void truncateTables(final DBConfig dbConfig) {
    System.out.println("TRUNCATE TABLES");
    Configuration cfg = HibernateConnect.getConfiguration(dbConfig);
    SessionFactory sf = cfg.buildSessionFactory(
            new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry());
    Session session = sf.openSession();//  w  ww. ja  v a 2s  .c om
    try {
        session.createSQLQuery("SET FOREIGN_KEY_CHECKS=0").executeUpdate();
        Iterator<Table> iter = cfg.getTableMappings();
        while (iter.hasNext())
            session.createSQLQuery("TRUNCATE TABLE " + iter.next().getName()).executeUpdate();
    } finally {
        session.createSQLQuery("SET FOREIGN_KEY_CHECKS=1").executeUpdate();
        session.disconnect();
        session.close();
    }
}

From source file:de.tudarmstadt.ukp.lmf.transform.UBYHibernateTransformer.java

License:Apache License

public UBYHibernateTransformer(final DBConfig dbConfig) {
    super();// w  w w  .  j  a  v  a2 s . com
    Configuration cfg = HibernateConnect.getConfiguration(dbConfig);
    sessionFactory = cfg.buildSessionFactory(
            new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry());
}

From source file:de.tudarmstadt.ukp.wikipedia.api.hibernate.WikiHibernateUtil.java

License:Apache License

public static SessionFactory getSessionFactory(DatabaseConfiguration config) {

    if (config.getLanguage() == null) {
        throw new ExceptionInInitializerError("Database configuration error. 'Language' is empty.");
    } else if (config.getHost() == null) {
        throw new ExceptionInInitializerError("Database configuration error. 'Host' is empty.");
    } else if (config.getDatabase() == null) {
        throw new ExceptionInInitializerError("Database configuration error. 'Database' is empty.");
    }/*from  w w w.j ava  2 s.co m*/

    String uniqueSessionKey = config.getLanguage().toString() + config.getHost() + config.getDatabase();
    if (!sessionFactoryMap.containsKey(uniqueSessionKey)) {
        Configuration configuration = getConfiguration(config);
        StandardServiceRegistryBuilder ssrb = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties());
        SessionFactory sessionFactory = configuration.buildSessionFactory(ssrb.build());
        sessionFactoryMap.put(uniqueSessionKey, sessionFactory);
    }
    return sessionFactoryMap.get(uniqueSessionKey);
}

From source file:de.uniwue.info6.database.map.conf.HibernateUtil.java

License:Apache License

/**
 *
 *
 * @return/*www .  j  a  v a  2s . c  om*/
 */
private static SessionFactory buildSessionFactory() {
    try {
        Cfg prop = Cfg.inst();

        Configuration hibernate = new Configuration().configure("hibernate.cfg.xml");
        hibernate.setProperty("hibernate.bytecode.use_reflection_optimizer", "false");
        hibernate.setProperty("hibernate.search.autoregister_listeners", "false");
        hibernate.setProperty("hibernate.current_session_context_class", "thread");
        hibernate.setProperty("hibernate.connection.driver_class", "org.mariadb.jdbc.Driver");
        hibernate.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLInnoDBDialect");

        hibernate.setProperty("hibernate.connection.url",
                "jdbc:mariadb://" + prop.getProp(PropertiesFile.MAIN_CONFIG, PropString.MASTER_DBHOST) + ":"
                        + prop.getProp(PropertiesFile.MAIN_CONFIG, PropString.MASTER_DBPORT)
                        + "?autoReconnect=true");

        hibernate.setProperty("hibernate.default_catalog",
                prop.getProp(PropertiesFile.MAIN_CONFIG, PropString.MASTER_DBNAME));
        hibernate.setProperty("hibernate.connection.username",
                prop.getProp(PropertiesFile.MAIN_CONFIG, PropString.MASTER_DBUSER));
        hibernate.setProperty("hibernate.connection.password",
                prop.getProp(PropertiesFile.MAIN_CONFIG, PropString.MASTER_DBPASS));

        StandardServiceRegistryBuilder serviceRegistryBuilder = new StandardServiceRegistryBuilder();
        serviceRegistryBuilder.applySettings(hibernate.getProperties());
        ServiceRegistry serviceRegistry = serviceRegistryBuilder.build();
        SessionFactory sessionFactory = hibernate.buildSessionFactory(serviceRegistry);

        return sessionFactory;
    } catch (Exception ex) {
        if (LOGGER != null) {
            LOGGER.error("Initial SessionFactory creation failed.", ex);
        }
        throw new ExceptionInInitializerError(ex);
    }
}

From source file:debop4k.data.orm.hibernate.HibernateEx.java

License:Apache License

/**
 * Hibernate {@link Configuration} ? ? {@link SessionFactory} .
 *
 * @param cfg Hibernate /*from  w ww.ja  v  a2 s .c  om*/
 * @return {@link SessionFactory} ?
 */
public static SessionFactory buildSessionFactory(@NonNull Configuration cfg) {
    log.info("SessionFactory  .");

    ServiceRegistry registry = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()).build();

    SessionFactory factory = cfg.buildSessionFactory(registry);

    log.info("SessionFactory  .");
    return factory;
}

From source file:dk.dma.ais.abnormal.event.db.jpa.JpaSessionFactoryFactory.java

License:Open Source License

/**
 * Create a new SessionFactory which can be used to connect to an H2 file based database.
 *//*from   w w  w. j ava2 s .c om*/
public static SessionFactory newH2SessionFactory(File dbFilename) {
    LOG.debug("Loading Hibernate configuration.");

    Configuration configuration = new Configuration()
            .setProperty("hibernate.connection.driver_class", "org.h2.Driver")
            .setProperty("hibernate.connection.url", buildH2ConnectionUrl(dbFilename))
            .setProperty("hibernate.connection.username", "sa").setProperty("hibernate.connection.password", "")
            .setProperty("hibernate.default_schema", "PUBLIC")
            .setProperty("hibernate.dialect", "org.hibernate.dialect.H2Dialect")
            //.setProperty("hibernate.show_sql", "true")
            .setProperty("hibernate.hbm2ddl.auto", "update").setProperty("hibernate.order_updates", "true")
            .setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider")
            .setProperty("hibernate.cache.use_second_level_cache", "true")
            .setProperty("hibernate.cache.use_query_cache", "true")
            .setProperty("hibernate.cache.region.factory_class",
                    "org.hibernate.cache.ehcache.EhCacheRegionFactory")
            .setProperty("hibernate.connection.provider_class",
                    "org.hibernate.c3p0.internal.C3P0ConnectionProvider")
            .setProperty("hibernate.c3p0.min_size", "1").setProperty("hibernate.c3p0.max_size", "32")
            .setProperty("hibernate.c3p0.initialPoolSize", "1").setProperty("hibernate.c3p0.timeout", "5000")
            .setProperty("hibernate.c3p0.acquire_increment", "1")
            .setProperty("hibernate.c3p0.max_statements", "50")
            .setProperty("hibernate.c3p0.idle_test_period", "300")
            .setProperty("hibernate.c3p0.numHelperThreads", "4").addAnnotatedClass(CourseOverGroundEvent.class)
            .addAnnotatedClass(SpeedOverGroundEvent.class).addAnnotatedClass(ShipSizeOrTypeEvent.class)
            .addAnnotatedClass(SuddenSpeedChangeEvent.class).addAnnotatedClass(DriftEvent.class)
            .addAnnotatedClass(CloseEncounterEvent.class).addAnnotatedClass(Zone.class)
            .addAnnotatedClass(Vessel.class).addAnnotatedClass(Behaviour.class)
            .addAnnotatedClass(TrackingPoint.class);

    StandardServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
            .applySettings(configuration.getProperties()).build();

    LOG.info("Starting Hibernate.");
    SessionFactory sessionFactory = configuration.buildSessionFactory(serviceRegistry);
    testConnection(sessionFactory);
    LOG.info("Hibernate started.");

    return sessionFactory;
}