[h2] Re: unable to write: the database is read only after system crash

2013-10-02 Thread Dieter Cailliau
Yes I'm using 2-phase-commit because I use xa-datasource (this is an xml element in jboss' standalone-full-ha.xml), but I never really found out how to configure the thing (jboss as 7.2.0.Final with h2) to perform recovery. I've pasted the config xml below. Note: having recovery is also not 'a

[h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-10-02 Thread Bert Roex
The DB2 Mode in H2 is quite complete although we use the WITH UR syntax in some queries which does not seem to be supported. Could you please expand the DB2 Mode to allow the use of the WITH UR DB2 syntax? -- You received this message because you are subscribed to the Google Groups H2

[h2] AggregateFunction and DatabaseEventListener#setProgress

2013-10-02 Thread Nicolas Fortin (OrbisGIS)
Hi, AggregateFunction and table function can be time consuming, as h2 provide a way to get the current task progression. I'm wondering if there is a way to acquire the Connection's DatabaseEventListener ? Regards, -Nicolas Fortin Atelier SIG IRSTV FR CNRS 2488 -- You received this message

Re: [h2] corrupt database 1.3.168

2013-10-02 Thread Dieter Cailliau
I'm sure the corruption was not there using 1.3.161 because its just an empty scheme I created once back then (i can send it if it helps). Whatever happens in that file later on, happens by a more recent h2.jar (1.3.168 in this report). I completely understand there's nothing you can do

[h2] H2 Clustering with more than 2 nodes

2013-10-02 Thread dcheney
I'd be grateful for your insights into a design idea so that I don't head down a dead-end road. Alternatives appreciated! Our requirement is for a relatively small DB with a low rate of transactions. I'd like to be able to have a db clone on each of 3 nodes. Clients would be directed to one

[h2] Small MVMap reopen bug?

2013-10-02 Thread Brian Bray
This test throws a Map is closed exception (in 1.3.173) and I don't believe it should. Looks like MVMap.openMap(...) is not checking for !old.isClosed()? @Test public void testMVMapClearReOpen() { // open MVMap File f = new File(System.getProperty(java.io.tmpdir), cache.data);

[h2] Re: H2 Clustering with more than 2 nodes

2013-10-02 Thread dcheney
sweet - I am able to cluster 3 nodes, where cluster is defined as writes to the first server in a serverlist are replicated on the other (two) nodes. What I had reported in (2) was due to a misconfiguration - I still had only two nodes in a local configuration file read (and repeatedly

Re: [h2] Proposal: Trigger2 Interface

2013-10-02 Thread Gili
Ping. Can we at least open an issue to track this? I don't want this to fall through the cracks. Gili On Tuesday, July 30, 2013 8:11:33 PM UTC-4, Gili wrote: Hi Thomas, Good thing you asked for the updated test, because I now see a huge performance difference: Multiple