Hi Thomas

We have a web application that we distribute. Now when the user starts the server up the first time the database is being created or used at the location /ourdb/db. Now on Windows the directory /ourb is being created and used. But on Linux, unless you start up the web server as root, the directory /ourdb can not be created. What I am actually looking for is to create the location of the DB dynamically. Anything like this possible?

On Sep 26, 2008, at 11:57 PM, Thomas Mueller wrote:


Hi,

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 "/".

I don't understand - the URL /ourdb/db doesn't point to the directory
"/". It points to the directory "/ourdb/". You do have access to that
directory? If not, to what directory do you have access to? Or do you
want to use an in-memory database (that's also supported)?

What would be the recommended way to handle this on Linux?

This is not related to Linux only. Even on Windows, you can use
absolute directories or relative ones, such as:

jdbc:h2:file:/data/test (absolute)
jdbc:h2:file:data/test (relative to the current working directory)

Regards,
Thomas

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---


--
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