Read-only database

View: New views
3 Messages — Rating Filter:   Alert me  

Read-only database

by xolotl :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

How can I create a read-only HSQLDB instance? The
problem is that it keeps updating the timestamp
line in the properties file. Short of hacking the
source, is there any way to make it stop doing that?

Thanks,

-- O.L.


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Read-only database

by xolotl :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Precision; I don't really want a read-only db, as it needs
to be able to create temporary tables. However those go away
when the db is shut down and the only permanent change is
that timestamp, which I'd like to turn off. In short, read-
only-except-for-temporary-changes.

-- O.L.


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Re: Read-only database

by Fred Toussi-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Which version are you using?

You can edit the properties file and set readonly=true or
files_readonly=true
With version 1.9, you can also specifiy the properties as a connection
property.

Fred


On Wed, 30 Sep 2009 06:02 +0200, "Olivier Lefevre" <lefevrol@...>
wrote:

> Precision; I don't really want a read-only db, as it needs
> to be able to create temporary tables. However those go away
> when the db is shut down and the only permanent change is
> that timestamp, which I'd like to turn off. In short, read-
> only-except-for-temporary-changes.
>
> -- O.L.
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register
> now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user