In that particular project the budget didn't allow switching to Postgres so I bit the bullet and did a full recover of the database: * Upgraded H2 to latest stable version (1.55 or so) * Removed all references to older versions (the Wonder framework uses an older beta, our fork was a bit newer but still) * Run the recovery tool * Rebuild the database from the recovered data It took me at least three attempts until everything worked fine. Since then it's been running ok.
I think the problem originated from conflicting versions. You have to be extra-careful when upgrading to a later version, for example when the H2PlugIn.framework comes with a new version of the JAR. It is advised to do an SQL export and rebuild the database. You also have to monitor the h2.trace file. In this case it took a couple of months until the corruptions were evident in the application. - Marius On 18.09.2011, at 22:17, Pascal Robert wrote: > Did you switch to something else? I was thinking of using H2 for a open > source project (app to display events from multiple delegated calendars from > CalDAV servers), but if I would get data corruption, I don't think I will use > it :-) > >> I can't recommend it for production use though. We deployed H2 in a >> small-scale project and had some horrible data corruption issues. As far as >> I understand, H2 is maintained by a single developer. >> >> >> On 18.09.2011, at 12:59, Pascal Robert wrote: >> >>> +1 for H2. Not having to install a RDBMS and create a database in it is >>> cool, especially for demos/tutorials. >>> >>>> Hi Dan, >>>> >>>> If you're going embedded, I would recommend H2 simply based on my >>>> experience with it. At home, I'll frequently use H2 to develop with the >>>> intention to deploy on Postgres. I figure I keep my database options open >>>> this way, because it prevents any stupid temptations to build dependency >>>> on a single database. Anyway, I've had no migration problems with H2. I >>>> just wish it did deferred FK constraints (^_^) >>>> >>>> If you want your H2 db in your resources directory, you can find an >>>> example in the ERMoviesLogic framework. >>>> >>>> Ramsey >>>> >>>> >>>> On Sep 17, 2011, at 9:07 PM, Dan Beatty wrote: >>>> >>>>> Greetings gentlemen, David’s, and members of the Chuck Wagon gang, >>>>> I thought I would pick your brains for amount to find out from your >>>>> experience which of the “stand-alone” databases like Apache Derby, H2, >>>>> etc play well with Project Wonder’s migration frameworks. I have >>>>> noticed that Apple’s plugin for MySQL plays poorly, but Ramsey says that >>>>> Wonder’s MySQL plugin fixes that. Thus, what embedded databases play >>>>> well with ERMigration and what plugins do I need to make them work? What >>>>> special URL augmentation is necessary for WO to find such an embedded >>>>> database in say the Resources directory of a WO application? >>>>> >>>>> Any ideas? >>>>> >>>>> Thank you, >>>>> >>>>> Daniel Beatty >>>>> Computer Scientist, Detonation Sciences Branch >>>>> Code 474300D >>>>> 1 Administration Circle M/S 1109 >>>>> China Lake, CA 93555 >>>>> daniel.bea...@navy.mil >>>>> (LandLine) (760)939-7097 >>>>> (iPhone) (806)438-6620 >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/ramseygurley%40gmail.com >>>>> >>>>> This email sent to ramseygur...@gmail.com >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>>> >>>> This email sent to prob...@macti.ca >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/m.soutier%40starhealthcare.info >>> >>> This email sent to m.sout...@starhealthcare.info >> >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
