Confluence Docs 3.0 : Troubleshooting the Embedded Database (hSQL DB) This page last changed on Dec 02, 2007 by smaddox. #### 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. ### Connecting to the Embedded Database Connecting to the Embedded HSQL Database can be quite difficult. You may need to connect to the database to retrieve information, or for troubleshooting purposes. Please follow the instructions on how to you can connect to the embedded HSQL Database using the free Database Administration Tool DBVisualizer.

Document generated by Confluence on Nov 05, 2009 23:34