Re: [h2] How to get the list of all active connections in H2

http://h2database.com/html/grammar.html#information_schema -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to th

[h2] How to get the list of all active connections in H2

Is there a way to get the list of all active connections in H2? I am looking for something similar to V$SESSION which Oracle database provides? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving ema

Re: [h2] H2 - Buy Support / Buy Formal Training

Hi, > In this case the multiple indexes should help to get reasonable response time for complex queries It depends on the data and the queries. In some cases, a multi-column index is needed. > Do you have any idea how to do it? It depends on the data and the queries. This is not just for t

Re: [h2] H2 - Buy Support / Buy Formal Training

thanks for your response... We try to understand how to use multiple indexes because we don't want to run a full scan... We plan to use the H2 as Embedded , while the jvm heap with 32GB memory. We'll have many entries In this case the multiple indexes should help to get reasonable response

[h2] cross-transactional specifics of 'merge'

Hi! I investigated SQL command "merge" in multi-transactional environment. It seems to me that invocation of merge in one READ_COMMITTED transaction blocks other transactions that try to execute 'merge' for the same row till the first transaction is committed. Is it correct? -- You received t