Hi,

We are using H2 in the embedded mode, since users don't actually need any 
access to the DB itself and all is done trough Razuna. We have even started to 
convert XML and config files to small H2 instances since they are just really 
fast and you can even use the memory mode of H2 to speed up things even more.

Since I'm more comfortable with Oracle syntax I run H2 with the oracle 
compatible mode. That means 95% of all my code for Oracle just runs on H2 as 
well. Can you imagine how easy it was to support Oracle and H2 at the same time 
:-) We now support MySQL and MS SQL as well and H2 was/is a big help in between.

As I said earlier, make sure you grab the latest H2 release and just drop it 
into the lib folder of WEB-INF and remove the older one. Thus you get the new 
page store of the latest releases.

If you have any questions please feel free to ask.

Kind Regards,
Nitai

On Dec 15, 2009, at 8:33 PM, gt wrote:

> Nitai, it sounds like you are really pushing H2. Are you using it in
> server mode or embedded? Have you hit any limits or found problems
> with H2 in the way you are using it? I know you are an expert with
> Oracle and mySql so how does H2 compare? I will definitely look into
> updating. Any tips or things to avoid? We are using the ReadytoRun
> version of OBD with Jetty on CentOS on EC2. It really couldn't be
> easier!

--
See for yourself how easy it is to manage files today. Join the revolution!

Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
http://www.razuna.com/

Razuna - Open Source Digital Asset Management
http://www.razuna.org/

Follow us on Twitter
http://twitter.com/razunahq

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to