Completely disable log-file

331 views
Skip to first unread message

Stefan Handschuh

unread,
Apr 30, 2009, 1:56:23 PM4/30/09
to H2 Database
Hi,

I want to disable the creation of the h2-log files. Is that possible
yet?

Thanks!

Stefan

Thomas Mueller

unread,
May 4, 2009, 12:49:36 AM5/4/09
to h2-da...@googlegroups.com
Hi,

> I want to disable the creation of the h2-log files. Is that possible
> yet?

You can not disable creating the transaction log. Why do you want to
disable it? But you can disable writing to them:
http://www.h2database.com/html/grammar.html#setlog

Regards,
Thomas

Stefan Handschuh

unread,
May 6, 2009, 3:49:20 AM5/6/09
to h2-da...@googlegroups.com
If the database is used by (system)user A, the log-files owner is user
A. Now, if (system)user B tries to open the db, h2 tries to delete the
old log file which is not possible because A is the owner, and not B.



2009/5/4 Thomas Mueller <thomas.to...@gmail.com>:

Thomas Mueller

unread,
May 10, 2009, 4:37:38 AM5/10/09
to h2-da...@googlegroups.com
Hi,

I suggest to solve the access rights problem in the system. Currently
H2 creates temporary files, lock files (.lock.db), files for lobs
(.lob.db).

Regards,
Thomas

Stefan Handschuh

unread,
May 10, 2009, 1:47:45 PM5/10/09
to h2-da...@googlegroups.com
Well, thats not possible, because the file is created with user
permissions only. So no one else can delete it.
The lock-file is also completely disable-able.


2009/5/10 Thomas Mueller <thomas.to...@gmail.com>:
Reply all
Reply to author
Forward
0 new messages