HibernateConnection.java

package gui.editor.database;
import gui.editor.database.wrap.PayKind;
import gui.editor.database.wrap.Tariff;

import java.sql.Connection;
import java.util.Properties;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

/** êëàññ, êîòîðûé ñîçäàåò Hibernate.Session íà îñíîâàíèè Connection */
public class HibernateConnection {
	private SessionFactory sessionFactory;
	
	/** ñîçäàòü íà áàçå Connection Hibernate íàäñòðîéêó 
	 * @param hibernateDialect - "org.hibernate.dialect.FirebirdDialect"
	 * @throws âûáðàñûâàåò èñêëþ÷åíèå â ñëó÷àå, êîãäà íå óäàëîñü ñîçäàòü Hibernate 
	 * */
	public HibernateConnection(String hibernateDialect) throws Exception{
		//Connection connection 
		//DatabaseMetaData data=connection.getMetaData();
		//System.out.println(data.getDriverName());
		AnnotationConfiguration aconf = new AnnotationConfiguration();
		Properties properties=new Properties();
		properties.put("hibernate.dialect", hibernateDialect);
		//properties.put("hibernate.connection.driver_class", "org.firebirdsql.jdbc.FBDriver");
		//properties.put("hibernate.connection.url", "jdbc:hsqldb:mem:baseball");
		//properties.put("hibernate.connection.username", "sa");
		//properties.put("hibernate.connection.password", "");
		properties.put("hibernate.connection.pool_size", "1");
		properties.put("hibernate.connection.autocommit", "false");
		//properties.put("hibernate.cache.provider_class", "org.hibernate.cache.HashtableCacheProvider");
		//properties.put("hibernate.hbm2ddl.auto", "create-drop");
		//properties.put("hibernate.show_sql", "true");
		aconf.setProperties(properties);
		aconf.addAnnotatedClass(PayKind.class);
		aconf.addAnnotatedClass(Tariff.class);
		sessionFactory=aconf.buildSessionFactory();		
	}
	public Session openSession(Connection connection){
		return sessionFactory.openSession(connection);
	}
	public void close(){
		System.out.println("close");
		this.sessionFactory.close();
	}
	
	public void finalize(){
		this.close();
	}
}