Can't call commit when autocommit=true

只是_曾经 2013-02-26 04:06:16
错误信息如下：


org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC commit failed

	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:610)

	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:709)

	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)

	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)



	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)



	at com.jauntway.service.UserinfoService$$EnhancerByCGLIB$$95ba1d2a.getUserinfo(<generated>)

	at com.jauntway.action.UserinfoAction.userLogin(UserinfoAction.java:42)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:597)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:441)



	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)

	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)



	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)

	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)



	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)



	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)



	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)



	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)



	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)



	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:89)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)

	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)

	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)

	at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)



	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)



	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)

	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)

	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)



	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

	at java.lang.Thread.run(Thread.java:619)

Caused by: org.hibernate.TransactionException: JDBC commit failed

	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:130)

	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:606)

	... 80 more

Caused by: java.sql.SQLException: Can't call commit when autocommit=true

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:930)

	at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1535)

	at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)

	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)

	at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)

	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)

	... 81 more


spring配置spring.xml如下：


<?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:aop="http://www.springframework.org/schema/aop"

	xmlns:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"

	default-autowire="byName">



		<import resource="classpath:spring-*.xml" />

	</beans>

...全文
300 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
只是_曾经 2013-02-26
  • 打赏
  • 举报
 回复
引用 4 楼 suciver 的回复:
在你spring-ds.xml中的dataSource的配置中加入 <property name="defaultAutoCommit" value="false" />
感谢，就是在找这句配置。。
suciver 2013-02-26
  • 打赏
  • 举报
 回复
在你spring-ds.xml中的dataSource的配置中加入 <property name="defaultAutoCommit" value="false" />
只是_曾经 2013-02-26
  • 打赏
  • 举报
 回复
引用 2 楼 suciver 的回复:
异常提示的很清楚了，你在提交事务的时候设置的autocommit=true是自动提交这种时候不支持事务
当然问题知道在那。但怎么配置呢？配置autocommit=false？
suciver 2013-02-26
  • 打赏
  • 举报
 回复
异常提示的很清楚了，你在提交事务的时候设置的autocommit=true是自动提交这种时候不支持事务
只是_曾经 2013-02-26
  • 打赏
  • 举报
 回复
spring-ds.xml如下： 
<?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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-2.5.xsd">

	<!-- 配置DBCP数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://192.168.0.176:3306/backstagemanager" />
		<property name="username" value="root" />
		<property name="password" value="jauntway" />
	</bean>
	
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
		
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.hbm2ddl.auto">false</prop>
				<prop key="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</prop>
			</props>
		</property>
		 <property name="mappingDirectoryLocations">
            <list>
                <value>classpath:com/jauntway/model/</value><!-- 加载hibernate的映射文件*.hbm.xml -->
            </list>
        </property>
		
	</bean>
	<!-- 配置事务管理器 -->
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<!-- 配置事务的传播特性 -->
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="save*" propagation="REQUIRED" />
			<tx:method name="update*" propagation="REQUIRED" />
			<tx:method name="delete*" propagation="REQUIRED" />
			<tx:method name="query*" propagation="REQUIRED" />
			<tx:method name="*" read-only="true" />
		</tx:attributes>
	</tx:advice>

	<!-- 配置参与事务的类或方法 -->
	<aop:config>
		<aop:pointcut id="allServiceMethod"
			expression="execution(* com.jauntway.service.*.*(..))" />
		<aop:advisor pointcut-ref="allServiceMethod" advice-ref="txAdvice" />
	</aop:config>
</beans>
spring-configBeans.xml如下： 

<?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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"
	>
	<!-- 配置dao层 -->
	<bean name="userinfoDao" class="com.jauntway.daoImpl.UserinfoDaoImpl">
	<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<bean name="memberinfoDao" class="com.jauntway.daoImpl.MemberDaoImpl">
	<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<bean name="fragmentinfoDao" class="com.jauntway.daoImpl.FragmentInfoDaoImpl">
	<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	
	<!-- dao层配置结束 -->
	
	<!-- 配置service层 -->
	<bean name="userinfoService"
		class="com.jauntway.service.UserinfoService">
		<property name="userinfoDao" ref="userinfoDao"></property>
	</bean>
	<bean name="memberinfoService"
		class="com.jauntway.service.MemberinfoService">
		<property name="memberinfoDao" ref="memberinfoDao"></property>
	</bean>
	<bean name="fragmentinfoService"
		class="com.jauntway.service.FragmentinfoService">
		<property name="fragmentinfoDao" ref="fragmentinfoDao"></property>
	</bean>
	<!-- service层配置结束 -->
	
	<!-- 配置Action层 -->
	<bean name="userinfoAction" class="com.jauntway.action.UserinfoAction">
		<property name="userinfoService" ref="userinfoService"></property>
	</bean>
	<bean name="memberinfoAction" class="com.jauntway.action.MemberinfoAction">
		<property name="memberinfoService" ref="memberinfoService"></property>
	</bean>
	
	<bean name="fragmentinfoAction" class="com.jauntway.action.FragmentInfoAction">
		<property name="fragmentinfoService" ref="fragmentinfoService"></property>
	</bean>
	<!-- action层配置结束 -->
</beans>
mysql数据库的基本操作语法
Ø 常用查询 MySQL结束符是“；”结束。 1、 显示所有数据库 show databases; 2、 删除数据库 drop database dbName; 3、 创建数据库 create database [if not exists] dbName;...中括号部分可选的，判断该数据不存在就...
Can't call commit when autocommit=true问题的解决方法
Can't call commit when autocommit=true问题的解决方法
Oracle数据库 大事务的数据更改对数据库内部的影响
当用户执行一条SQL对数据库进行更改操作的时候，我们知道数据是从磁盘读取到内存中进行更改操作的， 那么当这个SQL执行时间很长，而且修改数据量非常大，由于内存容量大小的原因，可能在事务没有commit 提交的情况...
Can‘t call commit when autocommit=true
Can't call commit when autocommit=true报错处理
关于Mysql 报错：Can't call commit when autocommit=true的问题解决
java.sql.SQLException: Can't call commit when autocommit=true at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at co...
Web 开发

81,094

社区成员

341,711

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章