Hi Sorry for the delay. This is a bug, the reason is that the connection is not in autocommit mode, and when you close the connection the changes are rolled back. I will try to fix this for the next release and add a test case.
Regards, Thomas On Fri, Sep 10, 2010 at 8:12 AM, Lothar <[email protected]> wrote: > Hello > > yesterday I tried to play with an H2 cluster and followed the > instructions on > http://www.h2database.com/html/advanced.html > > Similar as described I used > > java org.h2.tools.Server -tcp -tcpPort 9101 -baseDir server1 & > java org.h2.tools.Server -tcp -tcpPort 9102 -baseDir server2 & > > to start two independent h2 servers and clustered them using > > java org.h2.tools.CreateCluster -urlSource jdbc:h2:tcp://localhost: > 9102/test -urlTarget jdbc:h2:tcp://localhost:9101/test -user > sa -serverList localhost:9101,localhost:9102 > > This worked fine as well. I connected to the cluster using > > jdbc:h2:tcp://localhost:9101,localhost:9102/~/test > > created a table: > > create tabel person( > name varchar(20) > ) > > and inserted some data: > > insert into person values('Donald'); > insert into person values('Mickey'); > > A select on the person-table showed two rows - as expected > > Next I identified the Unix process that belongs to the 'server1' > instance and killed it. > > select-statements on the person-table still show two rows of data. > After reconnecting the table still exists, however the two rows of > data are gone. > > I deleted the database file of the former 'server1' instance and > reanimated server1: > java org.h2.tools.Server -tcp -tcpPort 9101 -baseDir server1 & > > Next I clustered 'server1' and 'server2'. After reconnecting to the > cluster the empty (!) table still exists. > > This is not the behaviour I expected. Did I make a mistake? > > Cheers > > Lothar > > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
