Springboot 整合 Hibernate5.x版本 获取Session的方法 及特殊情况下异常：org.hibernate.resource.jdbc.internal.LogicalConne

项目需要，使用seesion创建connection，用preparestatement做批量sql执行以及修复sql注入、提升sql执行效率等；

获取session的方式：

我使用的为第一种方式里的（2）。但注意：若当前DaoImpl类的泛型实体类并非数据库实际存在的时候，使用方式1，会报这种异常：

org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl@*** is closed

原因是：若Dao<T>的T类没有数据库实际映射，本地debug时没有问题，但是在部署到Liberty服务器上时，会报上述异常信息，提示你的session是closed的。这是我在项目开发中遇到的问题

另外，你的调用该持久化类的时候，需要有事务管理，否则一样会抛出该异常

1，使用@PersistenceContext注入entityManager即可。

@PersistenceContext
EntityManager entityManager

(1)：
Session session = (Session) entityManager.getDelegate();

(2):如果继承了JPADaoImpl
HibernateEntityManager hem = （HibernateEntityManager）this.getEntityManger()；

Session session = hem.getSession()

2.使用sessionFactory方法：

@Resource

SessionFactory sessionFactory;

Session session3= sessionFactory.getCurrentSession();
获取Session时，要在使用的类上或者方法上添加事务管理@Transactional

3，sessionFactory需自行配置（此方式转载自于：http://www.yayihouse.com/yayishuwu/chapter/1071/）

1.在application.properties中根据自己的数据库连接，修改以下代码：

spring.datasource.url=jdbc:db2://localhost:60010/appdev:currentSchema=${schema}
spring.datasource.username=****
spring.datasource.password=****
spring.datasource.driver-class-name=com.ibm.db2.jcc.DBDriver



2.sessionFactory配置类：

package com.yun.lab.server.config;

import com.alibaba.druid.pool.DruidDataSource;

import org.hibernate.SessionFactory;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.bind.RelaxedPropertyResolver;


 
import org.springframework.context.ApplicationContextException;

import org.springframework.context.EnvironmentAware;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.Primary;

import org.springframework.core.env.Environment;

import org.springframework.orm.hibernate5.HibernateTransactionManager;

import org.springframework.orm.hibernate5.LocalSessionFactoryBean;

import org.springframework.orm.jpa.JpaTransactionManager;

import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;

import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;

import org.springframework.transaction.PlatformTransactionManager;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import org.springframework.util.StringUtils;

import javax.persistence.EntityManagerFactory;

import javax.sql.DataSource;

import java.beans.PropertyVetoException;

import java.io.IOException;

import java.sql.SQLException;

import java.util.Arrays;

import java.util.Properties;



@Configuration

@EnableTransactionManagement

public class DatabaseConfiguration implements EnvironmentAware {

   private Environment environment;

   private RelaxedPropertyResolver datasourcePropertyResolver;

   //从application.yml中读取资源

   @Override

   public void setEnvironment(Environment environment) {

       this.environment = environment;

       this.datasourcePropertyResolver = new RelaxedPropertyResolver(environment,"spring.datasource.");

   }



   //datasource

   @Bean(initMethod = "init", destroyMethod = "close")

   public DataSource dataSource() throws SQLException {


 
       DruidDataSource druidDataSource = new DruidDataSource();

       druidDataSource.setUrl(datasourcePropertyResolver.getProperty("url"));

       druidDataSource.setUsername(datasourcePropertyResolver

               .getProperty("username"));

       druidDataSource.setPassword(datasourcePropertyResolver

               .getProperty("password"));

       druidDataSource.setDriverClassName(datasourcePropertyResolver

               .getProperty("dataSourceClassName"));

       druidDataSource.setInitialSize(1);

       druidDataSource.setMinIdle(1);

       druidDataSource.setMaxActive(20);

       druidDataSource.setMaxWait(60000);

       druidDataSource.setTimeBetweenEvictionRunsMillis(60000);

       druidDataSource.setMinEvictableIdleTimeMillis(300000);

       druidDataSource.setTestWhileIdle(true);

       druidDataSource.setTestOnBorrow(false);

       druidDataSource.setTestOnReturn(false);  

       return druidDataSource;

   }



   //sessionFactory

   @Bean

   public LocalSessionFactoryBean sessionFactory() throws SQLException{

       LocalSessionFactoryBean localSessionFactoryBean = new LocalSessionFactoryBean();

       localSessionFactoryBean.setDataSource(this.dataSource());

       Properties properties1 = new Properties();

       properties1.setProperty("hibernate.hbm2ddl.auto","none");

       properties1.setProperty("hibernate.dialect","org.hibernate.dialect.MySQL5InnoDBDialect");

       properties1.setProperty("hibernate.show_sql","true");

       localSessionFactoryBean.setHibernateProperties(properties1);

       localSessionFactoryBean.setPackagesToScan("com.yun.lab.server.dts.domain.*");

       return localSessionFactoryBean;

   }

   @Bean("sessionFactory")

   @Primary

   public SessionFactory sessionFactory(LocalSessionFactoryBean localSessionFactoryBean) throws

           PropertyVetoException, IOException {

       SessionFactory sessionFactory = localSessionFactoryBean.getObject();

       return sessionFactory;

   }

   //txManager事务开启

   @Bean("transactionManager")

   public HibernateTransactionManager txManager() throws SQLException {

       HibernateTransactionManager hibernateTransactionManager = new HibernateTransactionManager();

       hibernateTransactionManager.setSessionFactory(sessionFactory().getObject());

       return hibernateTransactionManager;

   }

}