hibernate mysql锁表。 - JEECMS官方论坛|开源java cms,jsp cms,jsp bbs

50398712

级别: 秀才

UID: 181
积分:90 加为好友
威望: 0 精华: 0
主题:14 回复:11
注册时间:2009-06-22
在线时长:0

1# 发表于:2009-07-09 22:44:26 IP:123.6.*.*

2009-07-09 10:39 WARN  o.h.u.JDBCExceptionReporter - SQL Error: 1213, SQLState: 40001
2009-07-09 10:39 ERROR o.h.u.JDBCExceptionReporter - Deadlock found when trying to get lock; try restarting transaction
2009-07-09 10:39 ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:105) [hibernate-core-3.3.1.GA.jar:3.3.1.G
A]
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.1.GA.jar:3.3.
1.GA]
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) [hibernate-core-3.3.1.GA.jar:3.3.1.G
A]
        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) [hibernate-core-3.3.1.GA.jar:3.3.1.G
A]
        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) [hibernate-core-3.3.1.GA.jar:3.
3.1.GA]
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2382) [hibernate-core-3
.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335) [hibernat
e-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635) [hibernate-core-3
.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115) [hibernate-core-3.3.1.GA.jar:3.3.1.GA
]
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [h
ibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [hibernate-core-3.3.1
.GA.jar:3.3.1.GA]
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655) [spr
ing-orm-2.5.6.jar:2.5.6]
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransacti
onManager.java:732) [spring-tx-2.5.6.jar:2.5.6]
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManag
er.java:701) [spring-tx-2.5.6.jar:2.5.6]
.......
at $Proxy3*saveArticle(Unknown Source) [na:na]
        at com.jeecms.article.action.ArticleAct.save(ArticleAct.java:xxxx) [ArticleAct.class:na]
......
请问这种情况怎么解决？