Thomas, That explains a lot. Now that I commit everything works as expected.
Thanks Lothar On 15 Sep., 22:49, Thomas Mueller <[email protected]> wrote: > 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 > > athttp://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.
