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