Duplicate data at text table csv and .script

  • wes

    wes - 2009-10-13


    I am running hsqldb embedded and I have a text table which is mapped to a csv file.

    Sometimes (although very few times) I receive a DuplicateException after restarting my application and I have noticed that some lines that are already at the csv are also at .script file.

    I am doing shutdown compact. I also have noticed that sometimes after another restart it recovers.

    Can you help explaining the cause of this duplication ? The database was not shut down properly ?

    Thank you

  • Fred Toussi

    Fred Toussi - 2009-10-13

    It is possibly due to a lack of proper shutdown.

    The implementation has changed in 1.9 and it should not write any rows to the .script or .log file during operation. It writes all the rows to .script only at shutdown compact.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks