MiningHibernateUtil.java

/**
 * File ./src/main/java/de/lemo/dms/db/hibernate/MiningHibernateUtil.java
 * Lemo-Data-Management-Server for learning analytics.
 * Copyright (C) 2015
 * Leonard Kappe, Andreas Pursian, Sebastian Schwarzrock, Boris Wenzlaff
 * 
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
**/

/**
 * File ./main/java/de/lemo/dms/db/hibernate/MiningHibernateUtil.java
 * Date 2013-01-24
 * Project Lemo Learning Analytics
 */

package de.lemo.dms.db.hibernate;

import java.util.Map.Entry;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import de.lemo.dms.db.DBConfigObject;
import de.lemo.dms.db.mapping.*;

/**
 * Startup Hibernate and provide access to the singleton SessionFactory
 */
public final class MiningHibernateUtil {

	private static SessionFactory sessionFactory;

	private MiningHibernateUtil() {
	}

	public static void initSessionFactory(final DBConfigObject dbConfig) {
		MiningHibernateUtil.sessionFactory = MiningHibernateUtil.createSessionFactory(dbConfig);
	}

	/**
	 * a getter for the SessionFactory of the Mining DB
	 * 
	 * @return a session Factory for Mining DB sessions
	 */
	public static SessionFactory getSessionFactory() {
		if (MiningHibernateUtil.sessionFactory == null) {
			throw new IllegalStateException("No mining config set.");
		}
		return MiningHibernateUtil.sessionFactory;
	}

	private static SessionFactory createSessionFactory(final DBConfigObject dbConfig) {
		final Configuration config = new Configuration();

		// add properties from files
		for (final Entry<String, String> entry : dbConfig.getProperties().entrySet()) {
			config.setProperty(entry.getKey(), entry.getValue());
		}
		//Properties migrated from lemo.xml
		
		config.setProperty("hibernate.show_sql", "false");
		config.setProperty("hibernate.format_sql", "false");
		config.setProperty("hibernate.hbm2ddl.auto", "update");
		config.setProperty("hibernate.cache.use_second_level_cache", "false");
		config.setProperty("hibernate.cache.use_query_level_cache", "false");
		config.setProperty("hibernate.c3p0.acquire_increment", "3");
		config.setProperty("hibernate.c3p0.min_size", "3");
		config.setProperty("hibernate.c3p0.timeout", "60");
		config.setProperty("hibernate.c3p0.max_size", "100");
		config.setProperty("hibernate.c3p0.idleConnectionTestPeriod", "100");
		config.setProperty("hibernate.c3p0.max_statements", "0");
		config.setProperty("hibernate.c3p0.propertyCycle", "2");
		config.setProperty("hibernate.c3p0.autoCommitOnClose", "false");
		config.setProperty("hibernate.c3p0.numHelperThreads", "3");
		config.setProperty("hibernate.c3p0.validate", "true");
		config.setProperty("hibernate.c3p0.acquireRetryAttempts", "50");
		config.setProperty("hibernate.c3p0.acquireRetryDelay", "1000");
		config.setProperty("hibernate.c3p0.maxConnectionAge", "120");
		config.setProperty("hibernate.c3p0.automaticTestTable", "connection_test_table");
		config.setProperty("hibernate.c3p0.testConnectionOnCheckout", "true");
		config.setProperty("hibernate.connection.provider_class", "org.hibernate.connection.C3P0ConnectionProvider");
		
		
		
		// Meta
		config.addAnnotatedClass(Config.class);
		
		//Objects
		config.addAnnotatedClass(User.class);
		config.addAnnotatedClass(LearningObj.class);
		config.addAnnotatedClass(Course.class);
		config.addAnnotatedClass(Role.class);
		
		//Types
		config.addAnnotatedClass(LearningType.class);
		
		//Relations
		config.addAnnotatedClass(UserAssessment.class);
		config.addAnnotatedClass(CourseLearning.class);
		config.addAnnotatedClass(CourseUser.class);
		config.addAnnotatedClass(Attribute.class);
		
		config.addAnnotatedClass(LearningAttribute.class);
		config.addAnnotatedClass(CourseAttribute.class);
		config.addAnnotatedClass(UserAttribute.class);
		
		//Logs
		config.addAnnotatedClass(AccessLog.class);
		config.addAnnotatedClass(CollaborationLog.class);
		config.addAnnotatedClass(AssessmentLog.class);

		return config.buildSessionFactory();
	}

}