Dear Nitai, Have you tried using CACHE_SIZE=131072 to bump up H2's default cache from 16MB? In my case I have a web app that only uses H2 for read access so an in-memory database may make sense. I just can't get OpenBD to work with the jdbc:h2:mem:[path/db] setting. It will verify the datasource but when the app tried to make a query it gives an error saying the table is not found. If I change it back to jdbc:h2: [path/db] then everything works again.
--GT On Dec 22, 11:01 am, "Nitai @ Razuna" <[email protected]> wrote: > Hi > > My string for H2 looks like this: > > <hoststring>jdbc:h2:/absolutepath/db/razuna;AUTO_SERVER=TRUE;IGNORECASE=true;MODE=Oracle;</hoststring> > > Thought, not sure if in-memory mode is really great with OpenBD. It > only supports read db and not > write:http://www.h2database.com/html/features.html#in_memory_databases > > Kind Regards, > Nitai > > -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
