Re: can't load aliases

On 11/6/06, Colin Bell <col@xxxxxxxxxxx> wrote:
> On Mon, Nov 06, 2006 at 11:46:34AM -0700, Mark Neher wrote:
> >
> > I tried to go from a snapshot that I have used since February to 2.3 today
> > (I'm running Linux), and have had trouble with aliases.  Initially, I
> > couldn't save aliases, so I went from 2.3 to the latest snapshot, as I see
> > this has recently been fixed.  In both 2.3 final and the snapshot, I am
> > unable to load my previous aliases.  I can't find anything about this in the
> > change log or mailing lists, but I notice two things:
> >
> > -- in previous versions, the aliases are in .squirrel-sql/SQLAliases.xml;
> > the new version stores aliases in
> > .squirrel-sql/SQLAliases23.xml
> > -- in SQLAliases.xml, the reference is to <Bean
> > Class="net.sourceforge.squirrel_sql.fw.sql.SQLAlias">; in SQLAliases23.xml,
> > the reference is to <Bean
> > Class="net.sourceforge.squirrel_sql.client.gui.db.SQLAlias">.  I assume this
> > mismatch is why I can't load my old aliases, even when I copy SQLAliases.xml
> > into SQLAliases23.xml
> >
> > As I said, I can't find any notes on this -- is there an upgrade path on
> > this, either by script or manual editing, or do I have to re-enter all my
> > aliases from scratch ??
>
> Try renaming SQLAliases23.xml to something else, then start SQuirreL
> and your old aliases should load. I believe the 23 file is left over
> from the failed saving of aliases. If that works just delete the
> backed up 23 file.
>
> Robert Manning knows more about this so when its his time zone he may
> correct me and tell you the true story.
>
You nailed it, Colin.  I simply renamed the SQLAliases23.xml file that
was generated (I should say mangled) by the 2.3 final version running
inside of 1.4.2_05.  Then restarted the latest snapshot of SQuirreL
which correctly generates this file now (still running it in 1.4.2_05)
 I made a copy of my .squirrel-sql directory just in case, but I
didn't need to revert to it.  My aliases were preserved as the
SQLAliases.xml which is used in 2.2 and below is
only used to generate SQLAliases23.xml which is used by 2.3 (RC1,
RC2,final).  Mark, if you do this and still have trouble let me know.
We're planning a 2.3.1 release soon and this would certainly hold that
up if we learn that the problem isn't completely fixed.

Rob

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642