Hi, > I am currently using HSQLDB in a production application and getting > the occasional report of database corruption.
I also get occasional reports about corruption for H2. In my view that's not acceptable, and my highest priority is to understand and fix those problems. So far there are no reproducible test cases unfortunately. Maybe some cases are related to Tomcat that sets final static fields to null when re-loading the web application (I just recently found out more details about that), some cases may still be related to out of memory. Some other cases are related to 'power off'. There are already many tests but it seems not enough. Also, I am currently working on a better storage engine, I hope this will completely solve the problem. For those who have corrupted databases, could you provide more information? A reproducible test case would be great. > is H2 production ready? I think H2 is more corruption proof than HSQLDB but not as 'secure' as MySQL or PostgreSQL. I would say it is in the same category as Apache Derby. H2 checksums all parts of the data, so if there is a problem it is detected early. In most cases the data is recoverable (there is a recovery tool). Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
