9 messages in com.googlegroups.h2-databaseRe: Timeout trying to lock... [HYT00-50]
FromSent OnAttachments
Thomas WiradikusumaDec 19, 2007 12:20 am 
Thomas MuellerDec 22, 2007 1:29 am 
Thomas MuellerDec 22, 2007 1:31 am 
Thomas WiradikusumaDec 22, 2007 3:27 am 
Thomas MuellerDec 26, 2007 8:42 am 
Thomas WiradikusumaDec 26, 2007 7:52 pm 
Thomas WiradikusumaDec 26, 2007 8:23 pm 
Thomas MuellerDec 28, 2007 8:05 am 
Thomas WiradikusumaDec 28, 2007 9:14 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: Timeout trying to lock... [HYT00-50]Actions...
From:Thomas Mueller (thom@gmail.com)
Date:Dec 28, 2007 8:05:51 am
List:com.googlegroups.h2-database

Hi,

I have used the most recent version (1.0.63) but the following exception keep filling the log file: Caused by: 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)

The exception code 'HYT00-50' means you are using version 1.0.50. If you are using version 1.0.63, then the exception code would be HYT00-63. Could you check that the old version of H2 is not in the classpath?

how do I enable row level locking in H2? probably it's because the locking
level.

I don't think that is the problem, but H2 does not yet support row level locking. It does support multi version concurrency as an option by the way, but this feature is quite new.

Happy New Year!

Regards, Thomas