Hi all,

First off I like to say that H2 database is simply the best that has happened to the DB world. Small, fast, perfect. We use it for almost all of our projects and we love it.

Now on to the question which has bugged me lately. In one of our web application we have a default location for the database, meaning we have a parameter that looks like this;

jdbc:h2:file:/ourdb/db;

Since this call is initiated during the startup of the application a new database is being setup on the server system. Now the problem with Linux is that, unless the web server is run as root, this initialization fails, since the web server does not have permission to write to "/".

What would be the recommended way to handle this on Linux? I don't want to use the "~" since the database needs to be accessible and storing it into a users directory would be a hassle (permission wise again).

Thank you for your feedback.

Kind Regards,
Nitai

--
Roozani - memorize everywhere
http://www.roozani.com/

Razuna - Open Source Digital Asset Management with Web Content Management
http://www.razuna.com/

SixSigns - Enrich people’s lives and web experience
http://www.sixsigns.com
http://blog.sixsigns.com

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

Reply via email to