freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
getCatalogs() and getTables(),
Stephanie Lewis, 07/13/2000
- <Possible follow-up(s)>
-
Re: getCatalogs() and getTables(),
Bob Kline, 07/13/2000
- Re: getCatalogs() and getTables(), Bob Kline, 07/13/2000
-
Message not available
- Re: getCatalogs() and getTables(), Craig Spannring, 07/17/2000
-
Message not available
-
Message not available
- Re: getCatalogs() and getTables(), Stefan Bodewig, 07/17/2000
-
Message not available
Archive powered by MHonArc 2.6.24.