Hi,
Below is my H2 connection string:
*jdbc:h2:file:${dbstorage.path};DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;IFEXISTS=FALSE;AUTO_SERVER=TRUE;MULTI_THREADED=TRUE;CACHE_SIZE=131072;MVCC=FALSE;*
In my application at some point of time whenever I try to read data I get
below exception, could you please let me know if there is some param is
missing in my connection string mentioned above ?
*Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table
"DATABASEDOCSTATUS"; SQL statement:*
select jpadatabas0_.id as id1_0_, jpadatabas0_.aclChecksum as aclCheck2_0_,
jpadatabas0_.configName as configNa3_0_, jpadatabas0_.contentChecksum as
contentC4_0_, jpadatabas0_.createdDate as createdD5_0_,
jpadatabas0_.isAvailable as isAvaila6_0_, jpadatabas0_.metadataChecksum as
metadata7_0_, jpadatabas0_.modifiedDate as modified8_0_,
jpadatabas0_.referenceKey as referenc9_0_, jpadatabas0_.status as status10_0_
from DatabaseDocStatus jpadatabas0_ where jpadatabas0_.configName=? and
jpadatabas0_.referenceKey=? [50200-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.mvstore.db.MVTable.doLock1(MVTable.java:251)
at org.h2.mvstore.db.MVTable.lock(MVTable.java:195)
at org.h2.table.TableFilter.lock(TableFilter.java:180)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:616)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:371)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
at org.h2.command.Command.executeQuery(Command.java:202)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
at
com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52)
at
com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeQuery(HikariPreparedStatementProxy.java)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
-
Jai
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
