Shortly, there are the next problems:
- it is not checked, that saving of SQLAliases23.xml was successful and as a consequence, there is no rollback of unsuccessful overwriting SQLAliases23.xml,
- SQLAliases23.xml is always silently overwritten independent of was the configuration changed or not,
- there is no backup of SQLAliases23.xml
The long story.
I had no free space on my hard drive. The SQuirrel SQL Client was started before. I did not make changes in the configuration - just executed some SQL Statements and then closed the SQuirrel SQL Client.
Then I freed enough place on the disk. The SQuirrel SQL Client was started again. The "Aliases" window was empty!
I looked to the file "SQLAliases23.xml" - it contained not complete XML (strange, as I did not make any change).
Then I closed SQuirrel SQL Client and looked at "SQLAliases23.xml". It was overwritten to 10 bytes: "<Beans/>" !!!
So, the passwords, connection strings, aliases were lost.
SQuirrel SQL Client v. 2.6.7,
x86, Windows XP SP3, Sun JDK 1.6.0u7