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
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
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
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
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
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