H2 file locking

[Andrus Adamchik <an...@objectstyle.org>]

H2 DB has been mentioned as yet another embedded DB for us to support.

Judging from this [1], we can solve Modeler preferences DB  
concurrency problems using H2 "socket" locks. I was thinking of  
writing a similar socket-based mechanism for HSQLDB, but since  
somebody has already done it, we should use it. So an adapter for H2  
(CAY-884) becomes an even more attractive proposition.

Andrus

[1] http://www.h2database.com/html/frame.html?advanced.html% 
23file_locking_protocols&main

Re: H2 file locking

[Michael Gentry <bl...@gmail.com>]

I was actually looking at H2 a little bit earlier and was wondering if
it would help the modeler issues.  I'm certainly not opposed to
changing out the backend and that would also add H2 support, as you
mentioned.

What do others think?


On 10/19/07, Andrus Adamchik <an...@objectstyle.org> wrote:
> H2 DB has been mentioned as yet another embedded DB for us to support.
>
> Judging from this [1], we can solve Modeler preferences DB
> concurrency problems using H2 "socket" locks. I was thinking of
> writing a similar socket-based mechanism for HSQLDB, but since
> somebody has already done it, we should use it. So an adapter for H2
> (CAY-884) becomes an even more attractive proposition.
>
> Andrus
>
> [1] http://www.h2database.com/html/frame.html?advanced.html%
> 23file_locking_protocols&main
>