Skip to Content.
Sympa Menu

freetds - Re: getCatalogs() and getTables()

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: getCatalogs() and getTables()
  • Date: Thu, 13 Jul 2000 11:26:02 -0400 (EDT)


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





Archive powered by MHonArc 2.6.24.

Top of Page