Example usage for org.hibernate.cfg Configuration setProperty

Introduction

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

Prototype

public Configuration setProperty(String propertyName, String value) 

Source Link

Document

Set a property value by name

Usage

From source file:com.naval.persistencia.hibernate.HibernateUtil.java

public static synchronized void buildSessionFactory() {
    if (sessionFactory == null) {
        Configuration configuration = new Configuration();
        configuration.configure();/* w  w w. j a  v  a  2  s . com*/
        configuration.setProperty("hibernate.current_session_context_class", "thread");

        StandardServiceRegistryBuilder serviceRegistryBuilder = new StandardServiceRegistryBuilder();
        // If you miss the below line then it will complaing about a missing dialect setting
        serviceRegistryBuilder.applySettings(configuration.getProperties());
        ServiceRegistry serviceRegistry = serviceRegistryBuilder.build();

        sessionFactory = configuration.buildSessionFactory(serviceRegistry);

    }
}

---

From source file:com.netcore.hsmart.hibernate.HibernateUtil.java

private static SessionFactory buildSessionFactory() {

    try {/*ww  w  .j a va  2s  .  c o  m*/

        Configuration configuration = new Configuration();
        //configuration.configure("hibernate.cfg.xml");
        configuration.setProperty("hibernate.connection.driver_class", AppConstants.getWriteDbDriverClass());
        configuration.setProperty("hibernate.connection.username", AppConstants.getWriteDbUsername());
        configuration.setProperty("hibernate.connection.password", AppConstants.getWriteDbPassword());
        configuration.setProperty("hibernate.connection.url",
                "jdbc:" + AppConstants.getWriteDbJdbcType() + "://" + AppConstants.getWriteDbHost() + ":"
                        + AppConstants.getWriteDbPort() + "/" + AppConstants.getWriteDbName());
        configuration.setProperty("hibernate.dialect", AppConstants.getWriteDbDialect());
        configuration.setProperty("hibernate.show_sql", AppConstants.getWriteDbShowSql());
        configuration.setProperty("hibernate.current_session_context_class", AppConstants.getWriteDbCtxClass());
        configuration.setProperty("hibernate.c3p0.min_size", AppConstants.getWriteDbPoolMinSize());
        configuration.setProperty("hibernate.c3p0.max_size", AppConstants.getWriteDbPoolMaxSize());
        configuration.setProperty("hibernate.c3p0.timeout", AppConstants.getWriteDbTimeout());
        configuration.setProperty("hibernate.connection.autocommit", AppConstants.getWriteDbAutoCommit());
        configuration.setProperty("hibernate.connection.release_mode", AppConstants.getWriteDbReleaseMode());
        configuration.setProperty("hibernate.c3p0.idle_test_periods", AppConstants.getWriteDbIdleTestsPeriod());

        configuration.addAnnotatedClass(com.netcore.hsmart.hibernate.entities.SmsRequestData.class);
        configuration.addAnnotatedClass(com.netcore.hsmart.hibernate.entities.DlrResponseData.class);
        configuration.addAnnotatedClass(com.netcore.hsmart.hibernate.entities.DlrStatusMap.class);

        return configuration.buildSessionFactory(
                new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build());
        // Create the ServiceRegistry from hibernate.cfg.xml
        //            ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()//
        //                    .configure("hibernate.cfg.xml").build();
        //
        //            // Create a metadata sources using the specified service registry.
        //            Metadata metadata = new MetadataSources(serviceRegistry).getMetadataBuilder().build();
        //
        //            return metadata.getSessionFactoryBuilder().build();
    } catch (HibernateException ex) {

        System.err.println("Initial SessionFactory creation failed." + ex);
        throw new ExceptionInInitializerError(ex);
    }
}

---

From source file:com.nominanuda.hibernate.HibernateConfiguration.java

License:Apache License

private Configuration makeConfiguration() {
    //SessionFactory sessionFactory = metadataSources.buildMetadata().buildSessionFactory();
    final Configuration cfg = new Configuration();
    DBType dbType = inferDbType();/*from   w w  w . j a v  a2  s  . c  o m*/
    //Configuration cfg = new Configuration();
    if (dynamic) {
        cfg.setProperty("hibernate.default_entity_mode", "dynamic-map");
    }
    ;
    cfg.setProperty("hibernate.show_sql", showSql.toString())
            .setProperty("hibernate.connection.url", connectionUrl)
            .setProperty("hibernate.connection.username", username)
            .setProperty("hibernate.connection.password", password)
            .setProperty("hibernate.connection.useUnicode", "true")
            .setProperty("hibernate.connection.characterEncoding", "UTF-8")
            .setProperty("hibernate.connection.charSet", "UTF-8")
            .setProperty("hibernate.connection.driver_class", getDriverClass(dbType));

    //TODO pluggable
    if (c3p0) {
        cfg.setProperty("connection.provider_class", "org.hibernate.connection.C3P0ConnectionProvider")
                .setProperty("hibernate.c3p0.acquire_increment", "3")
                .setProperty("hibernate.c3p0.min_size", "30").setProperty("hibernate.c3p0.max_size", "100")
                .setProperty("hibernate.c3p0.max_statements", "300")
                .setProperty("hibernate.c3p0.acquireRetryAttempts", "2")
                .setProperty("hibernate.c3p0.acquireRetryDelay", "450")
                .setProperty("hibernate.c3p0.timeout", "5000").setProperty("hibernate.c3p0.idle_test", "300");
    }
    switch (dbType) {
    case HSQLDB:
        cfg.setProperty("hibernate.dialect", "org.hibernate.dialect.HSQLDialect")
                .setProperty("hibernate.jdbc.batch_size", "0");
        break;
    case MYSQL:
        cfg.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect")
        //.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver")
        ;
        break;
    default:
        throw new IllegalStateException();
    }
    Properties properties = cfg.getProperties();
    Environment.verifyProperties(properties);
    for (String res : resources) {
        cfg.addResource(res);
    }
    return cfg;
}

---

From source file:com.opengamma.util.db.tool.DbTool.java

License:Open Source License

public Configuration getHibernateConfiguration() {
    Configuration configuration = new Configuration();
    configuration.setProperty(Environment.DRIVER, getJDBCDriverClass().getName());
    configuration.setProperty(Environment.URL, getJdbcUrl());
    configuration.setProperty(Environment.USER, getUser());
    configuration.setProperty(Environment.PASS, getPassword());
    configuration.setProperty(Environment.DIALECT, getHibernateDialect().getClass().getName());
    configuration.setProperty(Environment.SHOW_SQL, "false");
    configuration.setProperty(Environment.CURRENT_SESSION_CONTEXT_CLASS, "thread");
    configuration.setProperty(Environment.TRANSACTION_STRATEGY,
            "org.hibernate.transaction.JDBCTransactionFactory");
    return configuration;
}

---

From source file:com.opengamma.util.db.tool.DbTool.java

License:Open Source License

public Configuration getTestHibernateConfiguration() {
    Configuration configuration = getHibernateConfiguration();
    if (getTestSchema() != null) {
        configuration.setProperty(Environment.DEFAULT_SCHEMA, getTestSchema());
    }/*w  w w  .  j  a  va  2  s .  c  o  m*/
    return configuration;
}

---

From source file:com.openkm.dao.HibernateUtil.java

License:Open Source License

/**
 * Get instance/*  w ww .j  ava2  s .co  m*/
 */
public static SessionFactory getSessionFactory(String hbm2ddl) {
    if (sessionFactory == null) {
        try {
            // Configure Hibernate
            Configuration cfg = getConfiguration().configure();
            cfg.setProperty("hibernate.dialect", Config.HIBERNATE_DIALECT);
            cfg.setProperty("hibernate.connection.datasource", Config.HIBERNATE_DATASOURCE);
            cfg.setProperty("hibernate.hbm2ddl.auto", hbm2ddl);
            cfg.setProperty("hibernate.show_sql", Config.HIBERNATE_SHOW_SQL);
            cfg.setProperty("hibernate.generate_statistics", Config.HIBERNATE_STATISTICS);
            cfg.setProperty("hibernate.search.analyzer", Config.HIBERNATE_SEARCH_ANALYZER);
            cfg.setProperty("hibernate.search.default.directory_provider",
                    "org.hibernate.search.store.FSDirectoryProvider");
            cfg.setProperty("hibernate.search.default.indexBase", Config.HIBERNATE_SEARCH_INDEX_HOME);
            cfg.setProperty("hibernate.search.default.exclusive_index_use",
                    Config.HIBERNATE_SEARCH_INDEX_EXCLUSIVE);
            cfg.setProperty("hibernate.search.default.optimizer.operation_limit.max", "500");
            cfg.setProperty("hibernate.search.default.optimizer.transaction_limit.max", "75");
            cfg.setProperty("hibernate.worker.execution", "async");

            // http://relation.to/Bloggers/PostgreSQLAndBLOBs
            // cfg.setProperty("hibernate.jdbc.use_streams_for_binary", "false");

            // Show configuration
            log.info("Hibernate 'hibernate.dialect' = {}", cfg.getProperty("hibernate.dialect"));
            log.info("Hibernate 'hibernate.connection.datasource' = {}",
                    cfg.getProperty("hibernate.connection.datasource"));
            log.info("Hibernate 'hibernate.hbm2ddl.auto' = {}", cfg.getProperty("hibernate.hbm2ddl.auto"));
            log.info("Hibernate 'hibernate.show_sql' = {}", cfg.getProperty("hibernate.show_sql"));
            log.info("Hibernate 'hibernate.generate_statistics' = {}",
                    cfg.getProperty("hibernate.generate_statistics"));
            log.info("Hibernate 'hibernate.search.default.directory_provider' = {}",
                    cfg.getProperty("hibernate.search.default.directory_provider"));
            log.info("Hibernate 'hibernate.search.default.indexBase' = {}",
                    cfg.getProperty("hibernate.search.default.indexBase"));

            if (HBM2DDL_CREATE.equals(hbm2ddl)) {
                // In case of database schema creation, also clean filesystem data.
                // This means, conversion cache, file datastore and Lucene indexes.
                log.info("Cleaning filesystem data from: {}", Config.REPOSITORY_HOME);
                FileUtils.deleteQuietly(new File(Config.REPOSITORY_HOME));
            }

            // Create database schema, if needed
            sessionFactory = cfg.buildSessionFactory();

            if (HBM2DDL_CREATE.equals(hbm2ddl)) {
                log.info("Executing specific import for: {}", Config.HIBERNATE_DIALECT);
                InputStream is = ConfigUtils.getResourceAsStream("default.sql");
                String adapted = DatabaseDialectAdapter.dialectAdapter(is, Config.HIBERNATE_DIALECT);
                executeSentences(new StringReader(adapted));
                IOUtils.closeQuietly(is);
            }

            if (HBM2DDL_CREATE.equals(hbm2ddl) || HBM2DDL_UPDATE.equals(hbm2ddl)) {
                // Create or update translations
                for (String res : ConfigUtils.getResources("i18n")) {
                    String oldTrans = null;
                    String langId = null;

                    // Preserve translation changes
                    if (HBM2DDL_UPDATE.equals(hbm2ddl)) {
                        langId = FileUtils.getFileName(res);
                        log.info("Preserving translations for: {}", langId);
                        oldTrans = preserveTranslations(langId);
                    }

                    InputStream isLang = ConfigUtils.getResourceAsStream("i18n/" + res);
                    log.info("Importing translation: {}", res);
                    executeSentences(new InputStreamReader(isLang));
                    IOUtils.closeQuietly(isLang);

                    // Apply previous translation changes
                    if (HBM2DDL_UPDATE.equals(hbm2ddl)) {
                        if (oldTrans != null) {
                            log.info("Restoring translations for: {}", langId);
                            executeSentences(new StringReader(oldTrans));
                        }
                    }
                }

                // Replace "create" or "update" by "none" to prevent repository reset on restart
                if (Boolean.parseBoolean(Config.HIBERNATE_CREATE_AUTOFIX)) {
                    log.info("Executing Hibernate create autofix");
                    hibernateCreateAutofix(Config.HOME_DIR + "/" + Config.OPENKM_CONFIG);
                } else {
                    log.info("Hibernate create autofix not executed because of {}={}",
                            Config.PROPERTY_HIBERNATE_CREATE_AUTOFIX, Config.HIBERNATE_CREATE_AUTOFIX);
                }
            }
        } catch (HibernateException e) {
            log.error(e.getMessage(), e);
            throw new ExceptionInInitializerError(e);
        } catch (URISyntaxException e) {
            log.error(e.getMessage(), e);
            throw new ExceptionInInitializerError(e);
        } catch (IOException e) {
            log.error(e.getMessage(), e);
            throw new ExceptionInInitializerError(e);
        }
    }

    return sessionFactory;
}

---

From source file:com.openkm.hibernate.HibernateUtil.java

License:Open Source License

/**
 * Get instance//from   w  w w.j a  v  a2  s . c  om
 */
public static SessionFactory getSessionFactory(Configuration cfg) {
    if (sessionFactory == null) {
        try {
            // Configuration
            cfg.setProperty("hibernate.dialect", "org.hibernate.dialect.HSQLDialect");
            cfg.setProperty("hibernate.connection.driver_class", "org.hsqldb.jdbcDriver");
            cfg.setProperty("hibernate.connection.url", "jdbc:hsqldb:mem:openkm");
            cfg.setProperty("hibernate.connection.username", "sa");
            cfg.setProperty("hibernate.connection.password", "");
            cfg.setProperty("hibernate.connection.pool_size", "1");
            cfg.setProperty("hibernate.connection.autocommit", "true");
            cfg.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.HashtableCacheProvider");
            cfg.setProperty("hibernate.hbm2ddl.auto", "create");
            cfg.setProperty("hibernate.show_sql", "false");
            cfg.setProperty("hibernate.format_sql", "true");
            cfg.setProperty("hibernate.use_sql_comments", "true");

            // Hibernate Search
            cfg.setProperty("hibernate.search.default.directory_provider",
                    "org.hibernate.search.store.FSDirectoryProvider");
            cfg.setProperty("hibernate.search.default.indexBase", "indexes");

            sessionFactory = cfg.buildSessionFactory();
        } catch (HibernateException e) {
            log.error(e.getMessage(), e);
            throw new ExceptionInInitializerError(e);
        }
    }

    return sessionFactory;
}

---

From source file:com.openwords.database.DatabaseHandler.java

License:Open Source License

private DatabaseHandler() {
    String host = "127.0.0.1";
    String port = "3306";
    String username = "root";
    String password = "han";
    String dbName = "openwordsdb";

    Configuration configuration = new Configuration();
    configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
    configuration.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver");
    configuration.setProperty("hibernate.connection.url",
            "jdbc:mysql://" + host + ":" + port + "/" + dbName + "?autoReconnect=true");
    configuration.setProperty("hibernate.connection.username", username);
    configuration.setProperty("hibernate.connection.password", password);

    configuration.setProperty("hibernate.connection.characterEncoding", "utf-8");
    //configuration.setProperty("hibernate.format_sql", "true");
    //configuration.setProperty("hibernate.show_sql", "true");
    configuration.setProperty("hibernate.connection.provider_class",
            "org.hibernate.c3p0.internal.C3P0ConnectionProvider");
    configuration.setProperty("hibernate.c3p0.idleConnectionTestPeriod", "600");
    configuration.setProperty("hibernate.c3p0.testConnectionOnCheckin", "true");

    configuration.addAnnotatedClass(UserInfo.class).addAnnotatedClass(Lesson.class)
            .addAnnotatedClass(Course.class).addAnnotatedClass(Sound.class).addAnnotatedClass(Comment.class)
            .addAnnotatedClass(Stats.class);

    sessionFactory = configuration.buildSessionFactory(
            new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build());
    sessionFactory.getStatistics().setStatisticsEnabled(true);

    UtilLog.logInfo(DatabaseHandler.class, "SessionFactory created");
}

---

From source file:com.persinity.ndt.datamutator.hibernate.HibernateConfig.java

License:Apache License

/**
 * @return {@link Configuration}//from  w  w w.j  a va 2 s  .  c o  m
 */
public Configuration getHibernateConfiguration() {
    Configuration configuration = new Configuration().configure();

    configuration.setProperty("hibernate.connection.url", dbConfig.getDbUrl());
    configuration.setProperty("hibernate.connection.username", dbConfig.getDbUser());
    configuration.setProperty("hibernate.connection.password", dbConfig.getDbPass());
    configuration.setProperty("hibernate.dialect",
            config.getStringDefault(HIBERNATE_DIALECT_KEY, DEFAULT_HIBERNATE_DIALECT));
    configuration.setProperty("hibernate.connection.driver_class",
            config.getStringDefault(HIBERNATE_DRIVER_CLASS_KEY, DEFAULT_HIBERNATE_DRIVER_CLASS));

    if (config.getBooleanDefault(HIBERNATE_DEBUG_KEY, false)) {
        configuration.setProperty("show_sql", "true");
        configuration.setProperty("format_sql", "true");
    }

    configuration.setNamingStrategy(new NamingStrategy(TABLE_PREFIX));

    return configuration;
}

---

From source file:com.persistent.cloudninja.utils.SessionFactoryConfigurer.java

License:Apache License

public SessionFactory createSessionFactoryForTenant(String tenantDB) {
    TenantDataConnectionEntity dataConnectionEntity = tenantDataConnectionDao.find(tenantDB.substring(4));
    StringBuffer strBufServerURL = new StringBuffer("jdbc:sqlserver://");
    strBufServerURL.append(dataConnectionEntity.getServer());
    strBufServerURL.append(";databaseName=");
    strBufServerURL.append(tenantDB);/* ww  w .  j a v a  2s . c o  m*/
    strBufServerURL.append(";");

    String userName = dataConnectionEntity.getUser();
    String password = dataConnectionEntity.getPassword();

    Configuration cfg = new Configuration();
    cfg.addClass(TaskList.class);
    cfg.setProperty("hibernate.dialect", "org.hibernate.dialect.SQLServerDialect");
    cfg.setProperty("hibernate.show_sql", "true");
    cfg.setProperty("hibernate.hbm2ddl.auto", "update");
    cfg.setProperty("hibernate.connection.driver_class", driverClassName);
    cfg.setProperty("hibernate.connection.url", strBufServerURL.toString());
    cfg.setProperty("hibernate.connection.username", userName);
    cfg.setProperty("hibernate.connection.password", password);

    return cfg.buildSessionFactory();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• »