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.
