 | Start a set with this search |
 | Include this search in one of my sets |
 | Exclude this search from one of my sets |
 | Permalink to these results Paste this link in email or IM: |
 | Atom feed for tracking future search results Paste this URL into your reader: |
9 messages in com.googlegroups.h2-databaseTimeout trying to lock... [HYT00-50]| From | Sent On | Attachments |
|---|---|---|
| Thomas Wiradikusuma | Dec 19, 2007 12:20 am | |
| Thomas Mueller | Dec 22, 2007 1:29 am | |
| Thomas Mueller | Dec 22, 2007 1:31 am | |
| Thomas Wiradikusuma | Dec 22, 2007 3:27 am | |
| Thomas Mueller | Dec 26, 2007 8:42 am | |
| Thomas Wiradikusuma | Dec 26, 2007 7:52 pm | |
| Thomas Wiradikusuma | Dec 26, 2007 8:23 pm | |
| Thomas Mueller | Dec 28, 2007 8:05 am | |
| Thomas Wiradikusuma | Dec 28, 2007 9:14 am |
| Permalink for this message Paste this link in email or IM: |
| Permalink for this thread Paste this link in email or IM: |
| Atom feed for this thread Paste this URL into your reader: |
| Subject: | Timeout trying to lock... [HYT00-50] | Actions... |
|---|---|---|
| From: | Thomas Wiradikusuma (wira...@gmail.com) | |
| Date: | Dec 19, 2007 12:20:31 am | |
| List: | com.googlegroups.h2-database | |
hello guys,
i'm experiencing this exception everytime I want to remove/save row.
org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table CONTENTASSETRESPONSE [HYT00-50] at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java: 1040) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java: 297) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java: 297) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: 48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: 242) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java: 298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java: 106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java: 578) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java: 662) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java: 632) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java: 314) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java: 116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java: 171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java: 204)
if I do this in sequence (assuming the record/row is there), I'm using Hibernate: - load from DB - change some value in the object (ex. obj.setName("thomas")) - remove from DB everything is OK
but if I create n threads (each thread handle different object <-- from different row), the expection happens, and the rows are not deleted BUT the data is changed (contents of "name" changed to "thomas").
i use Hibernate/Spring transaction support, Isolation read uncommitted, auto-commit.
any hint? thx in advance.
regards,