Hello,
Trying to use a clustered mode. For some unclear reasons, connection URL
like that did not work in Java application:
hibernate.connection.url=jdbc:h2:tcp://10.59.1.214:9092,10.59.1.215:9092/~/test
The same exact string did work fine in web UI and in console client
("Shell").
While I was trying to troubleshoot it, I noticed there is a newer version
released a couple of weeks ago, so I updated the binaries from 1.4.197 to
1.4.198, and now I cannot even create a cluster.
Started server on both nodes using this command:
~# java -cp h2/bin/h2*.jar org.h2.tools.Server -tcp -tcpAllowOthers -web
-webAllowOthers
Then, tried to join it to cluster (those IP addresses are for the
corresponding nodes of the cluster):
java -cp h2/bin/h2*.jar org.h2.tools.CreateCluster
-urlSource jdbc:h2:tcp:10.59.1.214:9092/~/test
-urlTarget jdbc:h2:tcp:10.59.1.215:9092/~/test
-user sa
-password sa
-serverList 10.59.1.214:9092,10.59.1.215:9092
And now I am getting this exception:
Exception in thread "main"
org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database "/root/test"
not found [90013-198]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:616)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:427)
at org.h2.message.DbException.get(DbException.java:205)
at org.h2.message.DbException.get(DbException.java:181)
at org.h2.engine.Engine.openSession(Engine.java:67)
at org.h2.engine.Engine.openSession(Engine.java:201)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:178)
at org.h2.engine.Engine.createSession(Engine.java:161)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:160)
at java.lang.Thread.run(Thread.java:748)
Those same commands were working fine with the previous version (1.4.197).
Documentation here <http://www.h2database.com/html/advanced.html#clustering>
says that CreateCluster should create the databases if needed:
*Use the CreateCluster tool to initialize clustering. This will
> automatically create a new, empty database if it does not exist. *
Looked throught the changelog, but have not found what can it be. Were
there some changes in the clustering mode, or it is some regression?
--
Artem
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
