Could not open Hibernate Session for transaction, 数据库连接超时解决方法
来源:互联网 发布:中国大数据企业排行榜 编辑:程序博客网 时间:2024/05/16 14:09
ssh项目,服务器开了一夜后,出现了这样的异常,在博客上找到了这样的解决方案,
- 异常:
- javax.servlet.ServletException: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:
- root cause
- org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:
- 解决方案:
- 1.
- 给jdbc url 增加 autoReconnect=true 一定能解决你的问题,可以定期观察一下 show processlist
- 改进方法如下:
- <property name="url" value="jdbc:mysql://localhost/数据库实例名
- 称?&useUnicode=true&characterEncoding=utf-8&autoReconnect=true"/>
- 2.
- 寻找支持重连的连接池。
- 注意:c3p0连接池支持重连;重连参数是:
- idleConnectionTestPeriod 设置空闲连接测试周期
- preferredTestQuery : 设置一查询语句,用于重连测试
- testConnectionOnCheckin设置为true
- testConnectionOnCheckout设置为true
- 在sessionFactory里配置:
- <property name="hibernateProperties">
- <props>
- <prop key="hibernate.autoReconnect">true</prop>
- </props>
- </property>
0 0
- Could not open Hibernate Session for transaction, 数据库连接超时解决方法
- Could not open Hibernate Session for transaction, 数据库连接超时解决方法
- Could not open Hibernate Session for transaction, 数据库连接超时解决方法
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction;
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction
- 解决Could not open Hibernate Session for transaction问题
- SSH框架Could not open Hibernate Session for transaction
- 解决Could not open Hibernate Session for transaction问题
- Hibernage错误:Could not open Hibernate Session for transaction
- 解决Could not open Hibernate Session for transaction
- Could not open Hibernate Session for transaction 解决方案
- 如何手工释放linux内存?
- mysql的常用的命令
- 360称该工具全面保护QQ用户的安全
- UltraEdit个性化定制-Hive QL代码折叠、函数列表及自动补全
- Linux芯片级移植与底层驱动(基于3.7.4内核)
- Could not open Hibernate Session for transaction, 数据库连接超时解决方法
- 协同推荐算法实践之Slope One的介绍
- [linux内存]linux内存学习(一)
- ncurses中经常使用的API
- INSERT ALL和INSERT FIRST语法
- Alternating Current
- 推荐系统相关算法(1):SVD
- SQL Server数据库入门学习总结
- iOS自定义tabbar,可以隐藏