Is it possible to set up H2 in a way, that only one instance in time
will write to the file, while reading will be possible to many?
For example if I will use lustre file system, and I will not handle
the data availability on db level, it could be great, if H2 could
handle that kind of approach...
Is this a stupid question - concerning H2 ?
Because I doubt that nobody knows answer to that kind of question :-)
On 4. Máj, 09:21 h., feci wrote:
> Is it possible to set up H2 in a way, that only one instance in time
> will write to the file, while reading will be possible to many?
>
> For examp
Hi,
no it's not stupid, sometimes the replies take some time :)
If the instances share the same network you could use AUTO_SERVER=TRUE
http://www.h2database.com/html/features.html?highlight=AUTO_SERVER&search=AUTO_SERVER#auto_mixed_mode
For a file-based concurrent access you'd have to use the m
Ok, I tried the SERIALIZED lock, and inserting was quite ok, if there
where couple of applications inserting to the same file.
If I run simple select like
select * from table limit 100
it was ok. But when I try this:
select * from table order by id limit 100
than this exception was thrown:
Fil
Hi,
we already have many test cases for the serialized mode, and there
were no regressions in the last builds. Therefore I think it's
something which isn't covered by the test cases. I'd like
investigating this, but I need you extracting a testcase from the
application. Is this possible? Could you