[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] Data loss after app server shutdown w/ HSQL
From:       "Fred Toussi" <fredt () users ! sourceforge ! net>
Date:       2011-11-08 20:19:21
Message-ID: 1320783561.1132.140660996362181 () webmail ! messagingengine ! com
[Download RAW message or body]

It's not related to remote_open.

When your server is started as part of your app, then its databases get
cleared when the app server restarts. It is considered part of app.

If you start the server as a separate process, this will not happen.

The database files should not get cleared by default. But if you disable
the log, then no data is logged until you perform a checkpoint.

As there are a few unknowns, you need to provide more information about
your database setup.

Fred

On Tuesday, November 08, 2011 7:39 PM, "Thilo-Alexander Ginkel"
<thilo@ginkel.com> wrote:
> Hi there,
> 
> 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)?
> 
> Thanks,
> Thilo
> 
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> 

------------------------------------------------------------------------------
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]