I have a splitDB configuration which is working fine. However when I move the database to another machine, configure the appropriate Properties for JDBC, I do not see the tables. The Forms, Queries and Reports are intact as these are part of the ODB file. I have copied all the neccessary database files as well viz:
-rwxr--r-- 1 hmadhi hmadhi 5163 May 27 15:36 mydb.script
-rwxr--r-- 1 hmadhi hmadhi 32768 May 27 15:36 mydb.data
-rwxr--r-- 1 hmadhi hmadhi 88 May 27 15:36 mydb.properties
Can someone help in determining why I the ODB file does not show the Tables? I do not want to manually create all tables.
I have using the following Datasource URL
jdbc: hsqldb:file:///path/to/odb/dir/ mydb;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
I have the hsqldb.jar file in the same dir as the odb and mydb files.