Skip to Content.
Sympa Menu

freetds - Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
  • Date: Tue, 8 Nov 2005 15:00:48 +0100

>
> 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




Archive powered by MHonArc 2.6.24.

Top of Page