[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
From:       "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio () vodafone ! com>
Date:       2005-11-08 14:59:31
Message-ID: F7F148C986A2A84F930FEB8C3B169EA002921119 () OPDMEXO01 ! omnitel ! it
[Download RAW message or body]

Well, just to define my point of view SQLSetConnectAttr(SQL_ATTR_CURRENT_CATALOG) require just the name of catalog so it's wrong to unquote catalog name. It seems that sql server jdbc driver from Microsoft use a quoted version for setCatalog however this is jdbc not odbc. 

freddy77

> -----Original Message-----
> From: freetds-bounces@lists.ibiblio.org 
> [mailto:freetds-bounces@lists.ibiblio.org] On Behalf Of 
> VZverev@genesis.spb.ru
> Sent: marted́ 8 novembre 2005 15.15
> To: FreeTDS Development Group
> Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
> 
> Perhaps Colin Bell has another opinions as author of 
> SQLConnection.java
> 
> Sincerely yours. 
> -------------------------------------------------------
> Vitaly Zverev, OCP DBA 8&8i
> Oracle E-Business Suite &
> Infiniband Linux Cluster Administrator
> Genesis Ltd., St.Petersburg, Russia
> 
>  
> 
> > -----Original Message-----
> > From: freetds-bounces@lists.ibiblio.org 
> > [mailto:freetds-bounces@lists.ibiblio.org] On Behalf Of 
> > ZIGLIO, Frediano, VF-IT
> > Sent: Tuesday, November 08, 2005 5:01 PM
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
> > 
> > > 
> > > 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
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS@lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> > 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

[prev in list] [next in list] [prev in thread] [next in thread]