之前软件在Server 2003 32位服务器上运行正常，换了dellR720 64位服务器以后，平均10个小时会报一次以上错误Servlet.service() for servlet action threw exception org.springframework.transaction.TransactionSystemException: Could not <em>commit</em> Hibernate transaction; nested exception is org.hibernate.TransactionException: <em>JDBC</em> <em>commit</em> failed
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
at com.mysql.jdbc.Connection.getMutex(Connection.java:3640)
at com.mysql.jdbc.Connection.<em>commit</em>(Connection.java:2242)
at org.hibernate.transaction.<em>JDBC</em>Transaction.<em>commit</em>AndResetAutoCommit(<em>JDBC</em>Transaction.java:139)
at org.hibernate.transaction.<em>JDBC</em>Transaction.<em>commit</em>(<em>JDBC</em>Transaction.java:115)，后来我把tomcat装到默认路径C:\Program Files（X86）底下，<em>数据</em>库也是在这，大约40小时报一次错，页面打印错误是HTTP500
The full stack trace of the root cause is available in the Apache Tomcat/6.0但是重启tomcat以后页面正常了，过一段时间又开始打印localhost.log文件了，这个错误有人说是由于<em>数据</em>库保持连接时间短，但是把那个时间设置长了又影响性能，求各位大神指导！！
服务器：dell R720 操作系统server2008 tomcat版本6.0.37，<em>数据</em>库用的mysql 5.0.27，实时<em>数据</em>采集用的twincat tcat_2100_1335
一、<em>问题</em>：redhat7环境下部署tomcat服务器，启动2、3天就会报如下错误：
严重: Servlet.service() for servlet action threw exception
org.springframework.transaction.TransactionSystemException: Could not <em>commit</em> Hibernate transaction; n...
mysql在进行如插入（insert）操作的时候需不需要<em>commit</em>，这得看你的存储引擎，
如果是不支持事务的引擎，如myisam，则是否<em>commit</em>都没有效的。
如果是支持事务的引擎，如innodb，则得知道你事物支持是否自动提交事务（即<em>commit</em>）
看自己的<em>数据</em>库是否是自动<em>commit</em>，可以使用mysql&gt; show variables like '%auto<em>commit</em>%';...
org.hibernate.TransactionException: <em>commit</em> failed
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.<em>commit</em>(AbstractTransactionImpl.java:187)
at com.dtdream.cloud.dao.common.AbstractHibernateDao.create(AbstractHibernateDao.java:161)
at com.dtdream.cloud.dao.common.AbstractHibernateDao$$FastClassBySpringCGLIB$$c6f6a568.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
at com.dtdream.cloud.openstack.service.OpenstackServiceRetryAspect.TransctionRetryAbstractDaoAdvice(OpenstackServiceRetryAspect.java:31)
at sun.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at com.dtdream.cloud.dao.impl.AliyunOmsDao$$EnhancerBySpringCGLIB$$3b8f60a5.create()
at com.dtdream.cloud.service.impl.OpenstackOmsService.getEcsOmsData(OpenstackOmsService.java:298)
at com.dtdream.cloud.service.impl.OpenstackOmsService.createOmsItem(OpenstackOmsService.java:68)
at com.dtdream.cloud.controller.OmsController.job(OmsController.java:1196)
at sun.reflect.GeneratedMethodAccessor798.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.TransactionException: unable to <em>commit</em> against <em>JDBC</em> connection
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:116)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.<em>commit</em>(AbstractTransactionImpl.java:180)
... 34 more
Caused by: java.sql.SQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:140)
at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:268)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:296)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:346)
at org.mariadb.jdbc.MySQLConnection.<em>commit</em>(MySQLConnection.java:225)
at com.mchange.v2.c3p0.impl.NewProxyConnection.<em>commit</em>(NewProxyConnection.java:1284)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112)
... 35 more
Caused by: org.mariadb.jdbc.internal.common.QueryException: Deadlock found when trying to get lock; try restarting transaction
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:982)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1042)
at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289)
... 39 more
最近负责优化一个公司项目的<em>数据</em>库，先前用SQL SERVER 2000企业版快一年时间还不错，<em>问题</em>比较少，但到年初切换到SQL server 2005标准版，经常出<em>问题</em>，并发量一大i经常出现系统报错，看了一些JBOSS里系统那个错误日志，是两个方法有<em>问题</em>，错误很多是”jdbc <em>commit</em> failed“和死锁 。
但对这两个方法做了测试也没<em>问题</em>， 都是简单的查询，在网上...
在网上找了一篇文章
原文链接：https://www.cnblogs.com/fanwencong/p/5765136.html
在批量插入大量<em>数据</em>的时候，可以使用<em>JDBC</em>批量操作去执行插入，例如 插入100W条<em>数据</em>，分为10x10W去执行，每10W条<em>数据</em>执行一次插入操作
首先要更改一下MySQL的设置
set global max_allowed_packet = 100*1024*1...
结论：<em>commit</em>时会自动flush
<em>commit</em>后再进行flush会报错，如下
org.springframework.dao.InvalidDataAccessApiUsageException: no transaction is in progress; nested exception is javax.persistence.TransactionRequiredException: ...
程序如果长时间不进行<em>数据</em>库操作，那么<em>数据</em>源<em>中</em>的 Connection 很可能已经断开。其原因有可能是防火墙，或者连接的<em>数据</em>库设置的超时时间。这里使用的是 C3P0 连接 oracle <em>数据</em>库，引起的异常信息为：
org.springframework.transaction.TransactionSystemException: Could not roll back H
异常：
javax.servlet.ServletException: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.Transaction
我是用了SSH框架，发布到服务器上之后，差不多每天早上都会出现一种Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: <em>JDBC</em> begin failed: 的异常，网上百度了下几种方法，发现都不太好用，这里给大家推荐一个很方便的方法。
这
1、事务
（1）事务的概念
事务指逻辑上的一组操作，组成这组操作的各个单元，要不全部成功，要不全部不成功。
例如：A——B转帐，对应于如下两条sql语句
update account set money=money-100 where name=‘a’;
update account set money=money+100 where name=‘b’;
<em>数据</em>
unable to rollback aborted in-doubt branch on resource -error=XAER_RMFAIL, extra error=ORA-1031.Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges at oracle.jdbc.driver.
之前的系列文章从 CPU 和内存方面简单介绍了一下汇编语言，但是还没有系统的了解一下汇编语言，汇编语言作为第二代计算机语言，会用一些容易理解和记忆的字母，单词来代替一个特定的指令，作为高级编程语言的基础，有必要系统的了解一下汇编语言，那么本篇文章希望大家跟我一起来了解一下汇编语言。
汇编语言和本地代码
我们在之前的文章<em>中</em>探讨过，计算机 CPU 只能运行本地代码(机器语言)程序，用 C 语言等高级语...
