This method will not work for UTF chars.
I think if you include a directory listing of the files and
the contents of
the .properties file before you attempt to open with the
.log included, we
may find out what's going wrong.
Also, you should be using a recent version of the engine.
Fred
----- Original Message -----
From: "Sascha Pollok" <hsqldb pollok.net>
To: "HSQLdb user discussions"
<hsqldb-userlists.sourceforge.net>
Sent: 19 July 2006 17:59
Subject: Re: [Hsqldb-user] Recovering from a database crash
*Workaround*
Ok what I did not is to start the db without the .log-file
(its not using
it anyway) and then replay the log-file using a pipe to the
sql-console
which is working quite nicely if I add a semicolon after
each line.
The only problem I am still facing is with importing special
characters
with accents etc. These utf-8 chars are written like \u####
in the
log-file but when I send them like this, they end up with
the \ being
escaped to \u005c .. if I use \\u#### I end up having one
\ and one \
escaped like \u005c. Each of them are followed by the
original hex-key.
Any idea on this? If yes, this should be it and I can go on
doing other
things  )
Thanks
Sascha
On Wed, 19 Jul 2006, fredt wrote:
> If there is an error in the .log file, or memory runs
out, you will get a
> console message but the database starts with the data
up to the point it
> could read the log.
>
> Fred
> ----- Original Message -----
> From: "Sascha Pollok" <hsqldbpollok.net>
> To: "HSQLdb user discussions"
<hsqldb-userlists.sourceforge.net>
> Sent: 19 July 2006 12:46
> Subject: Re: [Hsqldb-user] Recovering from a database
crash
>
>
> Fred,
>
> > Strange, but can be fixed by editing the
.properties file and changing
> the
> > property "modified", from
"no" to "yes" (it should read
"modified=yes").
>
> thats exactly what I did. I changed modified=no to
modified=yes but it
> is still not inserting data from the .log-file. Instead
it starts up quite
> fast and deletes the .log-file.
>
> Any more ideas?  I am
completely lost here *sigh
>
> Thanks
> Sascha
>
> > If the tables contain a lot of rows, you may need
to allocate a large
> > maximum memory value when you run the Java
command to start any
> > application
> > or tool that accesses the database.
> >
> > Fred
> >
> > ----- Original Message -----
> > From: "Sascha Pollok" <hsqldbpollok.net>
> > To: <hsqldb-userlists.sourceforge.net>
> > Sent: 19 July 2006 12:26
> > Subject: [Hsqldb-user] Recovering from a database
crash
> >
> >
> > Folks,
> >
> > good morning. I am not familiar with HSQLDB
actually but currently
> > need to assist someone who is using one (and is
not familiar with it
> > either ).
> >
> > What I have is a database that uses memory-tables
only. It somehow
> > crashed - I dont know the circumstances. What I
have is a .script
> > file that obviously starts with CREATE statements
and some data
> > stuff and then a bigger .log file that comprises
most of the data
> > (because it has not been checkpointed for some
time).
> >
> > Now, when putting the .log-file, the .script-file
and the .properties
> > file alltogether and start the hsqldb-server, it
opens the database
> > with the tables and data from the .script-file but
does not read the
> > .log-file. Instead it creates an empty .log-file
and I end up with
> > some tables without the data from the .log-file.
> >
> > Does HSQLDB maybe need to see a .lck-file in order
to decide that it
> > needs to process the .log-file or can anyone give
some other hints here?
> > I tried to feed the .log file using a | to the
sql-shell but that
> > gives an out of memory error after some time :-/
> >
> > Thanks
> > Sascha
> >
> >
> >
------------------------------------------------------------
-------------
> > Take Surveys. Earn Cash. Influence the Future of
IT
> > Join SourceForge.net's Techsay panel and you'll
get the chance to share
> > your
> > opinions on IT & business topics through brief
surveys -- and earn cash
> > http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsqldb-userlists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
> >
> >
------------------------------------------------------------
-------------
> > Take Surveys. Earn Cash. Influence the Future of
IT
> > Join SourceForge.net's Techsay panel and you'll
get the chance to share
> > your
> > opinions on IT & business topics through brief
surveys -- and earn cash
> > http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> > _______________________________________________
> > Hsqldb-user mailing list
> > Hsqldb-userlists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/hsqldb-user
> >
>
>
------------------------------------------------------------
-------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get
the chance to share
> your
> opinions on IT & business topics through brief
surveys -- and earn cash
> http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-userlists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
>
>
------------------------------------------------------------
-------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get
the chance to share
> your
> opinions on IT & business topics through brief
surveys -- and earn cash
> http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-userlists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>
------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys
-- and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Hsqldb-user mailing list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys
-- and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Hsqldb-user mailing list
Hsqldb-userlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
|