#676 SQLAliases23.xml was emptied silently

All
open
Colin Bell
Core (461)
5
2014-07-27
2008-10-23
Yaroslav Sokolov
No

Hi,

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.

Regards,
Yarick.

My Profile:
SQuirrel SQL Client v. 2.6.7,
x86, Windows XP SP3, Sun JDK 1.6.0u7

Discussion

    • summary: SQLAliases23.xml was emptied silently empty --> SQLAliases23.xml was emptied silently