Re: [h2] Multiple independent H2 databases within one JVM

2015-07-03 Thread Basil Bourque
Is that metadata all unloaded upon closing that particular database? I expect to shut down any database not currently in use by a user. On Thursday, July 2, 2015 at 6:22:34 AM UTC-7, Noel Grandin wrote: > > Just note that we load all metadata for a given database into memory at > startup. > > S

Re: [h2] Multiple independent H2 databases within one JVM

2015-07-03 Thread Noel Grandin
Yes On 2015-07-03 09:11 AM, Basil Bourque wrote: Is that metadata all unloaded upon closing that particular database? I expect to shut down any database not currently in use by a user. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsub

Re: [h2] Multiple independent H2 databases within one JVM

2015-07-03 Thread Basil Bourque
Regarding Vaadin, the "Application" class/idea was one of the major changes in Vaadin 7 from Vaadin 6. That class/idea are gone. Now we have the much more flexible "VaadinSession" that wraps a Servlet session, and owns one or more instances of one or more "UI" classes. Each "UI" instance is the

Re: [h2] Database corruption on 1.3.176: any suggestions on how to avoid?

2015-07-03 Thread Rob Van Dyck
Hi Thomas, Thanx for your initial reply. We would really like to get to the bottom of this and find out what's wrong. I still have two questions: 1. Is there any way to know for sure a database is consistent? Eg. By running Recover with -trace and -transactionLog? Will this check all

Re: [h2] Database corruption on 1.3.176: any suggestions on how to avoid?

2015-07-03 Thread Thomas Mueller
Hi, > Is there any way to know for sure a database is consistent? The statement "script to " will detect most corruptions. It will not detect corruptions in just the secondary indexes, but those are quite rare. > We have a (new) corrupted database from a machine that isn't suffering from unexpec

Re: [h2] Slow SELECT using IN operator

2015-07-03 Thread Noel Grandin
Hmmm, that all looks fairly normal. Is it possible you could run the performance profiler (see here: http://h2database.com/html/performance.html#built_in_profiler) and post the result? Either that or a self-contained test-case. -- You received this message because you are subscribed to the G

Re: [h2] Where is org.h2.upgrade.v1_1.Driver ?

2015-07-03 Thread Ivan Codescratch
Thanks for the reply On Wednesday, July 1, 2015 at 2:16:05 PM UTC+2, Thomas Mueller wrote: > > Hi, > > This is in a separate jar file, you can download it from here: > http://h2database.com/html/download.html - "Database Upgrade Helper File". > > It is needed to upgrade a (very old) H2 version