[h2] log and undo_log

I don't understand the difference between these two. The docs on the "set" commands are pretty sparse, but both mention transactions. Are they explained anywhere? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group an

Re: [h2] Maven pom misses some informations for version 1.3.173

Everything is fine now (I don't know how and why...), but important thing is that the pom is fine again. Thanks for your time. On Wednesday, September 11, 2013 10:42:31 PM UTC+2, Tony Chemit wrote: > > I create a issue https://issues.sonatype.org/browse/MVNCENTRAL-368 > > On Wednesday, Septembe

Re: [h2] strategies for large transactions

Thanks! On Thursday, September 12, 2013 9:39:16 AM UTC-7, Thomas Mueller wrote: > > Hi, > > For memory problems: > > What I usually first use is "jmap -histo " to get an overview. It > usually works with recent versions of Java, sometimes you have to try a few > times and sometimes you have to u

Re: [h2] strategies for large transactions

Hi, For memory problems: What I usually first use is "jmap -histo " to get an overview. It usually works with recent versions of Java, sometimes you have to try a few times and sometimes you have to use -F. Rarely you have to use -histo:live. Afterwards, if I need to further analyze, I use -XX:+

Re: [h2] Need help with query

Hi, This is a generic SQL question. I would simplify the question and ask it at StackOverflow.com Regards, Thomas On Thu, Sep 12, 2013 at 12:38 AM, Anders wrote: > Hi, > > I need help with creating a query. > > Currently it looks like this > > SELECT > COUNT(*) AS ALERTS, > EXTRACT (YEAR FRO

Re: [h2] MVStore#getRetainVersion() appears to always return -1

Hi, MVStore.getRetainVersion is used internally by MVMap.removeUnusedOldVersions. Maybe the method should be renamed, and a new method getRetainVersion should be added that returns the value you passed in the setter. And you are right the "if" statement is strange: if (currentStoreVersion >=

Re: [h2] Using MVStore in OSGi

Hi, > I think i had H2 DB running in osgi a few years ago I'm quite sure you are not the only person who ever used H2 in OSGi :-) FilePath is old. > > Well, is there a stack trace? Could you post it? > No error or stack trace... it just stops.. In my experience Java threads don't "just stop" :-

[h2] lots of schemes vs lot of tables?

Hi, I need to store lot of data (even millions of records) on an small bunch of tables for many users (thousands). What would be would be the best approach? 1. Create one schema per user, so each user would have its own private table: select * from USER_N.TABLE_X 2. Create one table shared by

[h2] Re: Data loss with H2 HA / Clustered Mode

Hi Noel & Thomas, We are going to perform some tests with the H2 clustering using a tool to simulate a troublesome network. Once we have established how H2 behaves exactly I will post up our current problems with H2 (unless we don't manage to break it in the way I believe we can). I u

Re: [h2] Database corrupted after java.lang.ArrayIndexOutOfBoundsException

Hi Thomas, thanks for the answer. The only solution we found effective was in fact to delete and recreate the database. Since then we haven't found corruption problems. Regards Federico On Wednesday, September 11, 2013 8:05:47 PM UTC+2, Thomas Mueller wrote: > > Hi, > > The error code "[5-