Hi, The two files in this link used in conjunction should provide a reasonable exampl
- https://gist.github.com/cwdesautels/11188409 The test case is: 1. Run BackupTest: 1. Create a memFS database with DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE 2. Populate sample data 3. Close the connection 4. Run the backup utility, creating *test.zip* 5. Application exits 2. Run RestoreTest: 1. Run the restore utility to create a memFS database from the above *test.zip* with DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE 2. Create a connection 3. Read in the sample data 4. Application exits If anything is unclear, please let me know. On Monday, 28 April 2014 01:47:55 UTC-4, Thomas Mueller wrote: > > Hi, > > We would need a simple, reproducible test case. > > Regards, > Thomas > > > > On Friday, April 25, 2014, Carl Desautels <[email protected]<javascript:>> > wrote: > >> Hi, >> >> Thank you so much for you time in this community. >> >> >> The restore tool does not support database URLs and options. It should >> be: >> > Restore.execute("D:\\h2\test.zip", "memFS:", "test") >> >> I just tried this with the 1.4.177 release, and it is still not >> restoring. Just to make sure I tested running the Restore.execute() before >> and after creating a connection. >> >> On Friday, 25 April 2014 09:46:29 UTC-4, Thomas Mueller wrote: >>> >>> Hi, >>> >>> The parameters of Restore.execute are, as documented: >>> >>> >>> execute<http://h2database.com/javadoc/org/h2/tools/Restore.html#execute_String_String_String>(String >>> >>> zipFileName, String directory, String db) >>> >>> > Restore.execute("D:\\h2\test.zip", "memFS:test;DB_CLOSE_DELAY=-1") >>> >>> The restore tool does not support database URLs and options. It should >>> be: >>> >>> Restore.execute("D:\\h2\test.zip", "memFS:", "test") >>> >>> >>> Regards, >>> Thomas >>> >>> >>> On Thu, Apr 24, 2014 at 5:40 PM, Carl Desautels <[email protected]>wrote: >>> >>>> Hi, >>>> >>>> The restore tool is not working as expected then, I updated the samples >>>> with all of your and Thomas's suggestions: >>>> >>>> https://gist.github.com/cwdesautels/11188409 >>>> >>>> The sample itself has been separated into 2 files, with the intention >>>> of running them separately to demonstrate use of the restore tool at a >>>> later time. >>>> >>>> The specific error is schema test is not found when the select * is >>>> run, meaning the restore tool ran without error but the test schema does >>>> not exist. >>>> >>>> >>>> On Thursday, 24 April 2014 10:47:50 UTC-4, Noel Grandin wrote: >>>>> >>>>> >>>>> >>>>> On 2014-04-24 16:42, Carl Desautels wrote: >>>>> > >>>>> > Is it possible to have the recovery tool recover a memFS database >>>>> from a backup. If not, can I request this feature for >>>>> > the below use case. >>>>> >>>>> >>>>> This should work: >>>>> >>>>> Restore.execute("D:\\h2\test.zip", "memFS:test;DB_CLOSE_DELAY=-1") >>>>> >>>>> >>>>> See here for how the last parameter works: >>>>> http://h2database.com/html/features.html#in_memory_databases >>>>> >>>>> -- >>>> 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 http://groups.google.com/group/h2-database. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> 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 http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
