[h2] Timeout trying to lock table problem

hi! This is error message. I execute commands update or insert query directly. I try to MVCC=TRUE to the database URL But This method is not solved. And How do I set up LOCK_TIMEOUT=1 ? How do I solve? Please help me. Thank you org.h2.jdbc.JdbcSQLException: Timeout trying to lock table

Re: [h2] IO Exception: "java.io.IOException: Stream Closed"; [90031-168]

changing the environment from windows to linux (I run eclipse on debian now) fixed the problem. I mount external resources as a network share and don't experience described problems anymore On Tuesday, July 8, 2014 1:41:21 PM UTC+2, Noel Grandin wrote: > > You are could try playing with cache se

Re: [h2] Timeout trying to lock table problem

On 2014-07-09 07:42 AM, Su Yeon Kim wrote: And How do I set up LOCK_TIMEOUT=1 ? You can increase the lock timeout by modifying the JDBC URL e.g. see here: http://h2database.com/html/grammar.html#set_lock_timeout But the best way is to improve the performance of your queries so that t

Re: [h2] Reduce space usage with repeated strings column values

Hi, There are two areas: data de-duplication, and data compression. ** Data De-Duplication ** For BLOB and CLOB, data de-duplication is used for version 1.3.x, but only up to some point. Version 1.4.x does not use it, as it deceases write performance, and only helps for fairly small databases. F

Re: [h2] IO Exception: "java.io.IOException: Stream Closed"; [90031-168]

Hi, For write performance reasons, even for Linux, I would avoid keeping the database files on a network drive, for H2 version 1.3.x. Version 1.4.x (the MVStore) should be be less problematic, as the number of write operations is much lower. It would be worth a try. The number of read operations

[h2] Re: Problem still persist on latest release(1.4.179) IndexOutOfBoundsException during executeBatch.

Again one more exception after build from trunk. Can anyone help here? 2014-07-09 15:26:30,531 ERROR [Job Manager 10] b.t.i.d.m.MemoryDatabaseLoader [MemoryDatabaseLoader.java:470] Exception connecting to database:General error: "java.lang.UnsupportedOperationException: Must contain at least tw

[h2] Problem with latest release(1.4.179) - java.lang.UnsupportedOperationException

2014-07-09 15:26:30,531 ERROR [Job Manager 10] b.t.i.d.m.MemoryDatabaseLoader [MemoryDatabaseLoader.java:470] Exception connecting to database:General error: "java.lang.UnsupportedOperationException: Must contain at least two entries [1.4.179/0]" [5-179] org.h2.jdbc.JdbcBatchUpdateException

[h2] ArrayIndexOutOfBoundsException with multiple Threads using h2-1.3.176

I get an unexpected IndexOutOfBounds-Exception in the LobStorageBackend when reading blobs from a table which gets concurrently updated from another thread (however the update is not performed on the blob-field). I attached a simple test case for that and I'm able to reproduce that quite rel

Re: [h2] Problem with latest release(1.4.179) - java.lang.UnsupportedOperationException

Sigh. Where is the rest of the exception? On 2014-07-10 01:29 AM, Vishwa wrote: 2014-07-09 15:26:30,531 ERROR [Job Manager 10] b.t.i.d.m.MemoryDatabaseLoader [MemoryDatabaseLoader.java:470] Exception connecting to database:General error: "java.lang.UnsupportedOperationException: Must contain a