Re: [h2] Declaring Functions as Source Code

2014-04-04 Thread Hans Hans
Hi, sorry, I have tested a little bit and have the wrong stack trace posted. here is the right for my first example: DROP ALIAS TEST_INDEX IF EXISTS; Ă„nderungen: 0 (1 ms) CREATE ALIAS TEST_INDEX AS $$ import org.h2.index.Index; @CODE String TEST_INDEX(Index idx,String test) { return test;

Re: [h2] Re: H2 Database Corruption Issues

2014-04-04 Thread David Anstee
Hi, We have not experienced any Out of Memory errors so far. We don't tend to receive any errors until the database is re-opened and the connection fails. I think this might be worth looking into further though as our application can sometimes require large amounts of memory for some

Re: [h2] MVStore / MVMap key iterator performance

2014-04-04 Thread Igor Castang
No problems I will go the separate map for keys way. Thanks. regards On Thursday, April 3, 2014 12:25:12 PM UTC-4, Thomas Mueller wrote: Hi, Keys are values are stored next to each other in the same page (first all keys, then all values). Currently, when reading a page, all keys and

Re: [h2] Re: H2 Database Corruption Issues

2014-04-04 Thread Ryan How
I'm really not sure sorry. I wouldn't think it would cause an issue if it doesn't OOM. Even in the event of OOM or power outage, process killed, etc, it still should be fairly safe. Can you post about your environment, JVM version, OS, JVM startup params etc? Do you access files on a network