java - H2:JdbcSQLException:此 CLOB 或 BLOB 引用超时

Question

在java中使用h2(调用getBytes函数)时，我收到以下错误。谷歌没有找到我任何地方。我想知道是否有人知道发生了什么事。

Caused by: org.h2.jdbc.JdbcSQLException: This CLOB or BLOB reference timed out: "533668/-3" [90039-190]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.store.LobStorageMap.getInputStream(LobStorageMap.java:287)
    at org.h2.value.ValueLobDb.getInputStream(ValueLobDb.java:384)
    at org.h2.value.ValueLobDb.getBytesNoCopy(ValueLobDb.java:318)
    at org.h2.value.ValueLobDb.getBytes(ValueLobDb.java:304)
    at org.h2.jdbc.JdbcResultSet.getBytes(JdbcResultSet.java:1059)
    at edu.illinois.cs.cogcomp.srl.caches.SentenceDBHandler$1.next(SentenceDBHandler.java:214)

Answer 1

例如，如果您有一个长时间运行的事务，则可能会出现此错误消息。您可以通过在数据库连接上设置 LOB_TIMEOUT 属性来增加超时。

Database setting LOB_TIMEOUT (default: 300000, which means 5 minutes). The number of milliseconds a temporary LOB reference is kept until it times out. After the timeout, the LOB is no longer accessible using this reference.

https://www.h2database.com/javadoc/org/h2/engine/DbSettings.html#LOB_TIMEOUT