Hi, -If only one row is corrupt I have to reinitialize the device as a > whole (determined by the system - it is quite complex and this is the > safest way). What exceptions can I except if one row or the whole db > is corrupt? >
Unless there is a hardware problem, rows don't get corrupt. But if there can be hardware problems such that any bytes in a file can change, then H2 (or any other database) will not work correctly. H2 does use checksums, but only partial checksums (the beginning, middle, and end of a page). H2 does ensure transactions are either committed or rolled back. -I found that opening a connection to a db takes quite a "long" time. > I suggest to keep the database open for a longer time. > > -So I tried to open several (1000) connections to the databases I suggest to only open a few connections (maybe 10 or so). Connections can be re-used. -Another issue i am facing is what happens when the server crashes > while DBs are locked? That shouldn't be a problem. They are unlocked automatically. It > seems that formally locked databases are opened very slowly after a > crash. > Opening a database can take about 0.5 seconds longer in that case. 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.
