package ar.com.impripost.impresion.config;

import java.util.Properties;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.transaction.annotation.EnableTransactionManagement;



import javax.sql.DataSource;

@Configuration
@EnableTransactionManagement
@PropertySource(value = {"classpath:jdbc.properties"})

public class ApplicationContextConfig {

	@Autowired
	private Environment env;

	@Bean
	public DataSource dataSource() {
		DriverManagerDataSource dataSource = new DriverManagerDataSource();

		dataSource.setDriverClassName(env.getProperty("jdbc.driverClassName"));
		dataSource.setUrl(env.getProperty("jdbc.url"));
		dataSource.setUsername(env.getProperty("jdbc.user"));
		dataSource.setPassword(env.getProperty("jdbc.password"));

		return dataSource;
	}

	@Bean
	public LocalSessionFactoryBean sessionFactory(){
		LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();

		sessionFactory.setDataSource(dataSource());
		sessionFactory.setPackagesToScan(new String [] {"ar.com.impripost.impresion.model"});
		sessionFactory.setHibernateProperties(getHibernateProperties());

		return sessionFactory;
	}

	private Properties getHibernateProperties() {
		Properties prop = new Properties();

		prop.put("hibernate.dialect", env.getProperty("sqlserver.dialect"));
		prop.put("hibernate.show_sql", env.getProperty("hibernate.show_sql"));
		prop.put("hibernate.format_sql", env.getProperty("hibernate.format_sql"));
		prop.put("hibernate.query.substitutions", env.getProperty("hibernate.query.substitutions"));
		prop.put("hibernate.connection.release_mode", env.getProperty("hibernate.connection.release_mode"));
		prop.put("hibernate.generate_statistics", env.getProperty("hibernate.generate_statistics"));

		return prop;
	}

	@Bean
	@Autowired
	public HibernateTransactionManager transactionManager(SessionFactory sessionFactory) {
		HibernateTransactionManager txtManager = new HibernateTransactionManager();
		txtManager.setSessionFactory(sessionFactory);

		return txtManager;
	}



}






# * * * * * * * * * * * * * * * * * * * * * * * * * * * *
# * Parametros de Conexion con la Base de Datos sql  *
# * * * * * * * * * * * * * * * * * * * * * * * * * * * *

jdbc.driverClassName=net.sourceforge.jtds.jdbc.Driver
jdbc.user=sistemas
jdbc.password=santana
jdbc.url=jdbc:jtds:sqlserver://W2008R2DB;instance=SIEDI;DatabaseName=SIEDI;




# * * * * * * * * * * * * * * * * * * * * * * * * * * * *
# *      Parametros de Configuracion de hibernate       *
# * * * * * * * * * * * * * * * * * * * * * * * * * * * *
sqlserver.dialect=org.hibernate.dialect.SQLServerDialect
hibernate.show_sql=true
hibernate.query.substitutions=true 'T', false 'F'
hibernate.connection.release_mode=after_transaction
hibernate.generate_statistics=true
hibernate.format_sql=true


# * * * * * * * * * * * * * * * * * * * * * * * * * * * *
# *   Parametros del pool de conexiones para c3p0       *
# * * * * * * * * * * * * * * * * * * * * * * * * * * * *
c3p0.minPoolSize=5
c3p0.maxPoolSize=20
c3p0.timeout=300
c3p0.max_statement=50
c3p0.testConnectionOnCheckout=false