getCatalogs() and getTables()

Bob Kline bkline at rksystems.com
Thu Jul 13 11:26:02 EDT 2000


On Thu, 13 Jul 2000, Bob Kline wrote:

> On Thu, 13 Jul 2000, Stephanie Lewis wrote:
> 
> > Hi there,
> >        I have the July 6/00 download of the JDBC source compiled..
> > I'm connecting to an SQL Server 7.0 and all standard queries work
> > fine. However, I can't get the DatabaseMetaData getTables() to work.
> > It calls getCatalogs() which throws an exception here:
> 
> Stephanie:
> 
> You might want to try this again once Craig has finished folding in the
> latest set of submitted patches.  It's working with my copy of the
> driver against SQL Server 7.0.

I left out one caveat.  It's working, except that the column names of
the returned result set don't match those prescribed in the JDBC spec.  
Instead of TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, and REMARKS
the driver returns cat, schem, name, type, and rem.  Once you figure
that out and adjust accordingly it works fine.

-- 
Bob Kline
mailto:bkline at rksystems.com
http://www.rksystems.com




More information about the FreeTDS mailing list