May I know if some organization gives support for H2 database related
issues. We are facing major problem due to h2 db corruption issue in
production.
Following is the log from trace.db
*06-20 00:00:19 jdbc[1404]: exception*
*org.h2.jdbc.JdbcSQLException: File corrupted while reading record
I even tried to contact the "Commercial Support" listed on
http://www.h2database.com/ but there is no response from Steve McLeod
(steve dot mcleod at gmail dot com).
Please suggest if there are any other "Commercial Support" available for H2
database?
On Monday, 27 June 2016 17:02:52 UTC+5:30
Can "anyone" say "anything" about this issue???
* Am I doing something wrong
* Is it a known fact that commit takes a *long* time when the database
becomes big
* or have I provided wrong or "to less" information for anyone to make
"any" statement?
Best regards
/Goran Schwarz
--
You received
the first thing you can try is turning off the MULTI_THREADED option, that is
still experimental.
After that, try dropping LOBs and just using regular fields.
Does this problem go away if you restart the application (but keep the DB) ? If so, you might have a very long-running
trsansaction, or
Hi,
I just noticed that ResultSet.getURl() is listed as unsupported. Would
someone please explain why that is? It seems pretty trivial to wrap a
String with a URI.create() call under the hood, no? Yes, I know that
end-users could do this too, but supporting the call is important in terms
of co
Hi Noel, and thanks for the answer!
MULTI_THREADED is normally OFF (it was just an test to see if that was
going to help, but it did not, so I'm running *without* that option now)
LOB: Sorry I can't remove the LOB columns, then I have to "redesign"
everything from scratch (meaning: breaking up
*Hi:*
*How can I abort a delete operation in a Before Delete Trigger? I do it by
throwing an exception if the condition does not allow the delete but
the row is still deleted from my table. Below is my code for the trigger:*
public class AlarmTableTriggers {
public static class AlarmMoni
*Hi:*
*The latest version (as read from the release note) supports the writing of
the triggers as source code. I could not find any example (similar to the
TriggerSample.java) to know how to do it. Appreciate if someone can provide
some written example for me to learn. Thxs in advance.*
--
Y
Hi
That is unfortunate, it sounds like something in the MVStore garbage collection
is taking too long.
Which is weird, because I run DBs of several G in size, and I don't see that
problem.
Unfortunately, that is all Thomas code, so I can't really help there.
That only thing that I can suggest