Re: [h2] MVCC + Multithreaded

But my import process as follows: - Create a new db from scratch - Create new tables - import data from the old version using jdbc+sql - create materilized views (calculated tables), set rights etc. - turn h2 off in production, copy there the newly created file and start again. So I don't think

[h2] How to display the output of the EXPLAIN ANALYZE command?

I am tracing the performance of a program with explain analyze command. I run this command in H2 console, and itt does give many useful information like that: EXPLAIN ANALYZE SELECT * FROM TEST; SELECT TEST.ID, TEST.NAME FROM PUBLIC.TEST /* PUBLIC.TEST.tableScan */ /*

Re: [h2] MVCC + Multithreaded

Hold your horses! I found one more client that accesses the database with version 186. I had forgotten all about it. It is a very difficult situation that just one client reading a little bit from the database will corrupt it. So beware of version 186 (and maybe others?). I will regenerate the

Re: [h2] MVCC + Multithreaded

Isn't a bit unnerving if any client can actually corrupt the database?. I thought it is the servers job to keep the database safe? On 8/05/2015 7:10 PM, Rami Ojares wrote: Hold your horses! I found one more client that accesses the database with version 186. I had forgotten all about it. It

Re: [h2] Backup mvcc+multithreaded

Either this, or use the backup SQL statement. With the MVStore storage, this should work very well. With the PageStore, it should also work, but I didn't test as much. I tried the BACKUP command and it seems to work. Then I made one test. I started the BACKUP sql command. While it was

Re: [h2] Moving from H2 1.3.176 to 1.4.187 results in sporadic ArrayIndexOutOfBoundsExceptions?

Hi, I don't know what the problem could be. There were no changes in this area. What is strange is: The exception says it is trying to read past the end of a page that is 2048 bytes long. The default page size is 4096 bytes, did you set it manually to 2048 bytes? According to the database URL it

Re: [h2] How to display the output of the EXPLAIN ANALYZE command?

Hi, Do you mean, how to get the information without having to change the SQL statements (without adding explain analyze)? You can't. Regards, Thomas On Friday, May 8, 2015, Kriss Lu zhenxin...@gmail.com wrote: I am tracing the performance of a program with explain analyze command. I run

[h2] JdbcPreparedStatement in Oracle mode don't honor treatEmptyStringsAsNull

Hi, Ah sorry, I thought the test already passes... You are right, this is unexpected. I have fixed it now. However, this is a tricky area. If I was you, I would avoid relying on this behavior of Oracle, because no other database works like this. Regards, Thomas On Wednesday, May 6, 2015,

[h2] Database corrupt after computer power failure.

Hi, Thanks a lot! I have analyzed the database file, and I think I know what the problem is. It looks like the disk (or operating system) re-ordered write operations, so that changes later in time (and later in the file) were written, but one earlier change (both in time and in the file) was not

[h2] Re: Accessing H2 via PostgreSQL ODBC driver

Hi Victor, Can you please list me the steps you use to connect h2 server via postgresql odbc driver. I am actually trying to connect Ruby with h2 database. One of the solution i read was we can do it via postgresql odbc driver. thanks syed On Friday, June 19, 2009 at 4:53:22 PM UTC-7, Victor

Re: [h2] NPE in at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:453) becuase of TRIGGER initialization..

Hi, OK I see, so you are running SQL statements while initializing the trigger. It sounds like we need to initialize the LOB storage before creating the triggers then... Patches are welcome! Regards, Thomas On Wednesday, May 6, 2015, Vitali vita...@gmail.com wrote: Hi, Thomas. I think

Re: [h2] NPE in at org.h2.store.LobStorageBackend.copyLob(LobStorageBackend.java:453) becuase of TRIGGER initialization..

I will provide a patch. Just 1 line of code is moved earlier in Database class and some minor change in Lob-related class, I tested and it works smoothly. If you have ever heard about SymmetricDS library for synchronization of databases, they do support H2, triggers are created automatically