Re: H2 running in Tomcat 7 produces memory leak reports in tomcat's detection mechanism

2012-04-27 Thread Jim
Ok. If you need anything else from me, please let me know. I assume that what I have provided so far is sufficient for your investigation? On Apr 26, 9:44 am, Thomas Mueller wrote: > Hi, > > > So as far as > > your comment that the connection pool is not disposed, there is an > > analysis on this

Re: Huge performance problem when using OR. Much faster(500* +) when using two SELECT and UNION

2012-04-27 Thread
Hi. I'm not able to reproduce your problem, can you post the creation table script? Att, Fred 2012/4/26 Frederico > Hi. This is because H2 uses only one index per logical table. Take a look > on using multiples indexes here: > http://www.h2database.com/html/performance.html#explain_plan > > At

Alias for arguments in TABLE function

2012-04-27 Thread Łukasz Drumiński
Hello, this is working fine: SELECT * FROM TABLE(ID NUMBER=(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)) but I need to do something like this: SELECT * FROM TABLE(GET_NUMBERS()) is this posible? I could create alias GET_NUMBERS for some Java method but I don't know how this method should look. I will be g

Re: Alias for arguments in TABLE function

2012-04-27 Thread Loic Petit
Hi, You could do the following prepared statement : SELECT * FROM TABLE(ID NUMBER=?) then you can set the parameter with a setObject(1,new Object[] {1,2,3,4,5,6,7,8,9,10}) If you really want to do an external java function (though I do not understand why), I suppose you could write SELECT * FROM

Clustering: are replicas consistent?

2012-04-27 Thread Groupes H2
Hello, Does H2 ensure that replicas are in a consistent state when clustering is enabled? I don't see any code ensuring that transactions will be executed in the same order at the different replicas. Am I missing something? Thank you, Vivien -- You received this message because you are subscrib

Re: Alias for arguments in TABLE function

2012-04-27 Thread Łukasz Drumiński
Loic, thanks for answer. My situation is that: I use on production Oracle database. Now, I'm trying to use H2 in integration tests. In application on production I use exacly this query: SELECT * FROM TABLE(GET_NUMBERS()) and its not good idea to change it. So I'am asking, is there any way to handle