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
email@hidden
(LandLine) (760)939-7097
(iPhone) (806)438-6620
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
|