FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Ok, Frediano, as you wish. 
> Squirrel has SQLConnection.java module (a nise setCatalog 
> wrapper), which could outperform my workaround:
>       public void setCatalog(String catalogName)
>               throws SQLException
>       {
>               validateConnection();
>               final Connection conn = getConnection();
>               final String oldValue = conn.getCatalog();
>               if (!StringUtilities.areStringsEqual(oldValue, 
> catalogName))
>               {
>                       try
>                       {
>                               conn.setCatalog(catalogName);
>                       }
>                       catch (SQLException ex)
>                       {
>                               // MS SQL Server throws an 
> exception if the catalog name
>                               // contains a period without it 
> being quoted.
>                               
> conn.setCatalog(quote(catalogName));     
> <-------------------- gotcha! 
>                       }
>                       
> getPropertyChangeReporter().firePropertyChange(IPropertyNames.CATALOG,
>                                                               
>                               oldValue, catalogName);
>               }
>       }
> 
>       perhaps it should looks like:
> 
>       if (!ex.getSQLState().equalsIgnoreCase("01000")) 
> conn.setCatalog(quote(catalogName));
>       else throw ex;  
> 
> Sincerely yours. 
> -------------------------------------------------------
> Vitaly Zverev, OCP DBA 8&8i
> Oracle E-Business Suite &
> Infiniband Linux Cluster Administrator
> Genesis Ltd., St.Petersburg, Russia
> 

Instead of ignoring 01000 warning you could test if getCatalog return
wanted catalog name.

freddy77