This page last changed on Jul 06, 2006 by ivan@atlassian.com.

java.sql.SQLException: User not found: SA

Also see http://hsqldb.sourceforge.net/doc/guide/ch01.html#N101C2 .

HSQLDB periodically must update its files to represent changes made in the database. In doing so, it must delete the current confluencedb.data file on the filesystem (beneath conf.home/database) and replace it with a new one.

If an administrator issues a shutdown on Confluence in this period, data can be lost, and is typically noticed by the error message, when starting Confluence up again, of 'User not found: SA' .

Users encountering this problem should seek to restore backups, contained in the backup directory beneath confluence.home. If daily backups have been turned off, and no other copy of data remains, the data is lost.

HSQLDB should not be used as a production database. It is included for evaluation purposes only.

Hibernate logging

It can be useful to enable detailed Hibernate logging when debugging problems with HSQL.

Document generated by Confluence on May 01, 2007 19:29