Re: [Hsqldb-user] Data loss after app server shutdown w/ HSQL

[Thilo-Alexander G. <th...@gi...>]

On Tue, Nov 8, 2011 at 19:39, Thilo-Alexander Ginkel <th...@gi...> wrote:
> there must be an obvious misunderstanding on my end as I cannot get
> HSQLDB opening a database via remote_open=true inside an app server to
> retain the data across an app server restart. I tried various options
> (such as supplying the shutdown=true property as part of the URL,
> disabling the log, etc.), but HSQL just 'forgets' all the data written
> during an uptime cycle.
>
> Is this a side-effect of using remote_open=true to open the database
> file? Do I need to issue an explicit SHUTDOWN command under these
> circumstances (I was under the impression that shutdown=true would
> take care of that)?

There is one important fact I forgot to mention: The HSQLDB (2.2.5)
server is running embedded within the application.

Regards,
Thilo