Am trying to do execute a CreateCluster operation. I have two databases on different machines started by:
java -cp c:\h2\bin\h2-1.4.192.jar org.h2.tools.Server -tcp -tcpPort 9101 -tcpAllowOthers -baseDir c:\Users\scottvm9 java -cp c:\H2\bin\h2-1.4.192.jar org.h2.tools.Server -tcp -tcpPort 9101 -tcpAllowOthers -baseDir c:\users\scottvm10 The CreateCluster command is: java -cp c:\h2\bin\h2-1.4.192.jar org.h2.tools.CreateCluster -urlSource "jdbc:h2:tcp://192.168.50.132:9101/~/server1/test" -urlTarget "jdbc:h2:tcp://192.168.50.128:9101/~/server1/test" -user <user> -password <password> -serverList 192.168.50.132:9101,192.168.50.128:9101 But I get the a FileNotFoundException on backup.sql: *Exception in thread "main" org.h2.message.DbException: IO Exception: "java.* *io.FileNotFoundException: backup.sql (The system cannot find the file speci* *fied)"; "backup.sql" [90031-192]* * at org.h2.message.DbException.get(DbException.java:168)* * at org.h2.message.DbException.convertIOException(DbException.java:3* *30)* * at org.h2.tools.RunScript.process(RunScript.java:333)* * at org.h2.tools.CreateCluster.process(CreateCluster.java:158)* * at org.h2.tools.CreateCluster.runTool(CreateCluster.java:81)* * at org.h2.tools.CreateCluster.main(CreateCluster.java:48)* *Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.FileNotFoun* *dException: backup.sql (The system cannot find the file specified)"; "backu* *p.sql" [90031-192]* * at org.h2.message.DbException.getJdbcSQLException(DbException.java:* *345)* * ... 6 more* *Caused by: java.io.FileNotFoundException: backup.sql (The system cannot fin* *d the file specified)* * at java.io.FileInputStream.open0(Native Method)* * at java.io.FileInputStream.open(Unknown Source)* * at java.io.FileInputStream.<init>(Unknown Source)* * at java.io.FileInputStream.<init>(Unknown Source)* * at org.h2.store.fs.FilePathDisk.newInputStream(FilePathDisk.java:32* *1)* * at org.h2.store.fs.FileUtils.newInputStream(FileUtils.java:218)* * at org.h2.tools.RunScript.process(RunScript.java:185)* * at org.h2.tools.RunScript.process(RunScript.java:328)* * ... 3 more* Can anyone tell me about this file backup.sql. i.e. should it be created by the createcluster operation? if so, where should I expect to find it. The documentation is a bit light on this -- 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.
