<? xml version = "1.0" encoding = "UTF-8" ?> < beans xmlns = "http://www.springframework.org/schema/beans" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:p = "http://www.springframework.org/schema/p" xmlns:context = "http://www.springframework.org/schema/context" xmlns:tx = "http://www.springframework.org/schema/tx" xmlns:aop = "http://www.springframework.org/schema/aop" xsi:schemaLocation =" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd" default-autowire = "byName" > < context:property-placeholder location = "classpath:jdbcConfig.properties" /> < bean id = "dataSource" class = "com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method = "close" > < property name = "driverClass" value = "${jdbc.driverClassName}" /> < property name = "jdbcUrl" value = "${jdbc.url}" /> < property name = "user" value = "${jdbc.username}" /> < property name = "password" value = "${jdbc.password}" /> < property name = "minPoolSize" value = "5" /> < property name = "maxPoolSize" value = "20" /> < property name = "maxStatements" value = "10" /> < property name = "idleConnectionTestPeriod" value = "3000" /> < property name = "loginTimeout" value = "300" /> </ bean > < bean id = "sessionFactory" class = "org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean" > < property name = "dataSource" > < ref local = "dataSource" /> </ property > < property name = "hibernateProperties" > < props > < prop key = "hibernate.show_sql" > true </ prop > < prop key = "hibernate.dialect" > org.hibernate.dialect.MySQL5Dialect </ prop > < prop key = "hibernate.format_sql" > true </ prop > < prop key = "hibernate.use_sql_comments" > true </ prop > </ props > </ property > < property name = "packagesToScan" value = "com" /> </ bean > < context:component-scan base-package = "com" /> < bean id = "transactionManager" class = "org.springframework.orm.hibernate3.HibernateTransactionManager" > < property name = "sessionFactory" ref = "sessionFactory" /> < property name = "dataSource" > < ref local = "dataSource" /> </ property > </ bean > < tx:annotation-driven transaction-manager = "transactionManager" /> </ beans >
以上配置是spring+hibernate+c3p0整合链接池配置,通过代码全注解的方式增加事物管理,连接池等
前不久一直被一个问题困扰着,
getHibernateTemplate().getSessionFactory().openSession();
通过这种方式打开的session不会自动关闭,现象时查询多次之后连接池满了,不会再继续查询了
日志信息如下
2014-06-06 15:16:50,654 [btpool0-4] DEBUG AbstractBeanFactory : Returning cached instance of singleton bean 'transactionManager' 2014-06-06 15:16:50,655 [btpool0-4] DEBUG AbstractPlatformTransactionManager : Creating new transaction with name [com.*.*.service.ActivityService.findAllByPage]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; '' 2014-06-06 15:16:50,655 [btpool0-4] DEBUG HibernateTransactionManager : Opened new Session [org.hibernate.impl.SessionImpl@4bdc0bc7] for Hibernate transaction 2014-06-06 15:16:50,655 [btpool0-4] DEBUG HibernateTransactionManager : Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@4bdc0bc7] 2014-06-06 15:16:50,655 [btpool0-4] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool@7bfbfeae [managed: 20, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@564389b7) 2014-06-06 15:16:50,656 [btpool0-4] DEBUG HibernateTransactionManager : Exposing Hibernate transaction as JDBC transaction [com.mchange.v2.c3p0.impl.NewProxyConnection@6a02938d] 2014-06-06 15:16:50,657 [btpool0-4] DEBUG BasicResourcePool : acquire test -- pool is already maxed out. [managed: 20; max: 20] 2014-06-06 15:16:50,657 [btpool0-4] DEBUG BasicResourcePool : awaitAvailable(): com.mchange.v2.c3p0.impl.NewPooledConnection@564389b7 2014-06-06 15:16:50,658 [btpool0-4] DEBUG BasicResourcePool : trace com.mchange.v2.resourcepool.BasicResourcePool@7bfbfeae [managed: 20, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@564389b7)
后来通过网上查找资料看到这么一篇内容
这个是hibernate 与spring 整合开发,让DAO继承了spring的HibernateDaoSupport,这样的确能够提高开发效率 ,但是不够灵活,而且使DAO层依赖于spring的api,增加了耦合。但是不考虑复用的话还可以。
下面一个一个的分析: this.getsession 实际上是调用了父类中的方法获得session。使用spring管理hibernate的SessionFactory的时候,这个方法会从session池中拿出一session.这样做有可能有问题,就是超session池连接数的时候,spring无法自动的关闭session。 不推荐使用
this.getHibernateTemplate().getSessionFactory().getCurrentSession() 从spring管理的sessionFactory中创建一个绑定线程的session.spring会根据该线程的执行情况来自动判断是关闭session还是延迟关闭。这样做可以避免手动的管理实务,同时一个线程最多开启和关闭一次session又可以提高程序的性能。 极力推荐使用这种方法
this.getHibernateTemplate().getSessionFactory().OpenSession 。这种方法从spring管理的sessionFactory中创建一个session,此session不是线程绑定的。当执行完一个实务的时候自动关闭session.这种方法不用手动管理实务,但是同一个线程多次的开启和关闭session,浪费系统资源和影响执行效率,正常情况下还是不要用了。
其中this.getSession这个方法我也用过,这个确实也会将连接关闭,当时对于楼主提到的问题不知道怎么测试 ,
第二个问题完美的解决了,我遇到的连接池无法关闭的问题而且楼主也推荐使用,应该找到最终的解决办法了
第三个,就是我前面一直用的,需要手动关闭连接
对于网上还有一种说法,
http://bbs.csdn.net/topics/340092096
问题已经解决,原来在配置hibernater时少配了一个属性: <prop key="hibernate.connection.release_mode">after_statement</prop> 唉!不懂是此属性值默认是on_close,就是session.close();时关闭连接,但我在调用这查询时,使用手动session.close();还是一样的结果。。。。
该配置对于我来说一点用都没有,不知道是什么场景下使用
不过总算搞定连接池问题了,已经工作的时候,也经常听别人说你们要用 getCurrentSession, 而不要新开连接,新开的需要自己手动关闭,大概道理就是这个了