I'm also interested in this feature, or I'd like to take a snapshot of an in memory h2 database and have the ability to rollback or reload to a snapshot.
My use case is this: - I am using H2 in embedded in memory mode. - I have a very large test database that takes minutes to seed and between test suites the database is reset by dropping and recreating. - I wanted to cache the seeded database and just replace the dirty database after a testsuite with a copy of the seeded database. I have tried the script command and combined it with fast importing(disable; log, referential integrity, auto-commit), but that isn't noticeably faster than the traditional method of resetting the database. I was attempting to use reflection to access to the databases hash-map but obtaining a deep copy was proving troublesome, that caused me to stumble onto this thread. On Thursday, 17 April 2014 11:16:52 UTC-4, Thomas Mueller wrote: > > Hi, > > You mean, the MVMap should be serializable? It's possible to do that. It's > possible to make almost every class serializable. But I don't see the value > in this case. Why do you want it? What are you trying to do? What problem > are you trying to solve? > > Regards, > Thomas > > > On Thu, Apr 17, 2014 at 4:41 AM, Frank Liu <[email protected]<javascript:> > > wrote: > >> >> -- >> 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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
