java.lang.RuntimeException: [50000-139]

[Noel L]

Hi,
I'm running Windows 7.  When attempting to print a report from an H2 database in LibreOffice Base the system hung and I had to use Task Manager to abort the process.  The database now seems to be corrupted and I get the error shown in the attached file.
I can recover the .h2 file from a previous backup, but that could mean re-entering quite a bit of data.  Is there any utility that I could use to fix this corruption?

Thanks,
Noel Lodge

[Noel Grandin]

http://h2database.com/html/advanced.html#using_recover_tool

[Marion & Noel Lodge]

Many thanks Noel.

I'll give the recover tool a try.

Noel

--

​N​

oel Lodge
lod...@gmail.com

--
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/YxFQPbdLacA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database+unsubscribe@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[Thomas Mueller]

Hi,

According to the error code, you are using quite an old version of H2 (build 139, which is from 2009 or 2010). I suggest to upgrade to a more recent version.

Regards,

Thomas

 

--
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 h2-database+unsubscribe@googlegroups.com.

[Marion & Noel Lodge]

Hi Thomas,

The reason I'm still on H2 build 139 is that it is the only version where I have been able to get the parameter -Dh2.identifiersToUpper=false to work.  (I use camel case for my Table and Field names.)

Recently I tried the latest H2 version again, but discovered that I needed to go into each Table definition and change identifiers there to camel case there, before it will work.  I was making some progress doing that, but then had trouble with my PC and decided it was time to upgrade to a new one.  Transferring all applications over is a long and tedious task, but the end is in sight, so I'll need to put moving to the latest H2 version on top of my priority list!

Thanks for pointing this out.

Noel

--
Noel Lodge
lod...@gmail.com

--

You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/YxFQPbdLacA/unsubscribe.

To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.