java.sql.Connection.commit() freezes after LOB modification with EXCLUSIVE connection

[GoogleCodeExporter]

See the attached unit test code to reproduce : when a table has a LOB column 
which is modified (with a minimum size) and when the connection to the H2 
database is exclusive, the java.sql.Connection.commit() after another update 
freezes. Instead, if java.sql.Statement.execute("commit") is called, everything 
works fine and there is no deadlock.
I expect the Connection.commit() to behave the same way.
There is no trouble with an in-memory database or if the connection is not 
exclusive but such workarounds are not easy to use in our context (we use 
layers such as liquibase and hibernate to access our H2 database and that 
prevents us from doing fine-grained tuning in some way)

Original issue reported on code.google.com by lrichard...@gmail.com on 24 Oct 2013 at 2:23

Attachments:

• H2Test.java

[GoogleCodeExporter]

This issue was detected on versions 1.3.171 and 1.3.174

Original comment by lrichard...@gmail.com on 24 Oct 2013 at 2:29

[GoogleCodeExporter]

Fixed in revision 5268

Original comment by noelgrandin on 25 Oct 2013 at 8:28

• Changed state: Fixed