getCatalogs() and getTables()

Stephanie Lewis slewis at thinweb.com
Thu Jul 13 10:15:35 EDT 2000


Greg,
        I downloaded the  "freetds_jdbc.snapshot.zip  233 Kb    Thu Jul 06 11:12:00
2000 Zip Compressed Data" source and compiled it. I am in fact running the drivers
on NT 4 workstation.

Greg Garrison wrote:

> Stephanie - Noticed your post. Sorry I don't have an answer for your problem but
> I would like to ask you if you have been successful at running these drivers on
> NT 4.0.  We are having a problem.  They run fine on our linux or sun servers but
> not on NT4. If so, which build or JAR are you using?  Much appreciated!
> ---------------------- Forwarded by Greg Garrison/JEFCO on 07/13/2000 09:23 AM
> ---------------------------
>
> Stephanie Lewis <slewis at thinweb.com> on 07/13/2000 08:38:44 AM
>
> Please respond to "TDS Development Group" <freetds at franklin.oit.unc.edu>
>
> To:   "TDS Development Group" <freetds at franklin.oit.unc.edu>
> cc:    (bcc: Greg Garrison/JEFCO)
>
> Subject:  [freetds] getCatalogs()  and getTables()
>
> 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:
>
> public java.sql.ResultSet getCatalogs()
>    throws SQLException
>    {
>    // XXX We should really clean up all these temporary tables.
>    String tmpName = "#t#" + UniqueId.getUniqueId();
>    final String sql =
>    " create table " + tmpName + "                                   " +
>    " (                                                              " +
>    "    q  char(30) not null,                                       " +
>    "    o  char(30) null,                                           " +
>    "    n  char(30) null,                                           " +
>    "    t  char(30) null,                                           " +
>    "    r  varchar(255) null                                        " +
>    " )                                                              " +
>    "                                                                " +
>    " insert into " + tmpName + " EXEC sp_tables ' ', ' ', '%', null " +
>    "                                                                " +
>    " select q from " + tmpName + "                                  " +
>    "";
>    java.sql.Statement   stmt = connection.createStatement();
>    java.sql.ResultSet   rs;
>
>    if (stmt.execute(sql))
>    {
>    throw new SQLException("Internal error.  Confused");
>    }
>
>    // Eat the data returned by the 'create table'
>    if (null != (rs = stmt.getResultSet()))
>    {
>    throw new SQLException("Internal error.  Confused");
>    }
>
>    // Eat the data returned by the 'insert'
>    if (null != (rs =
> stmt.getResultSet()))
> <<<<<<<<<<--------------------------------EXCEPTION THROWN HERE!
>    {
>    throw new SQLException("Internal error.  Confused.  Was expecting a
> result set.");
>    }
>
>    // now get the result set
>    if (null == (rs = stmt.getResultSet()))
>    {
>    throw new SQLException("Internal error.  Confused");
>    }
>    return rs;
>    }
>
> Are these implementations of these methods supposed to work or are they
> a work in progress? Any thoughts.
>
> Hope you can provide some insight,
>                                                         Stephanie
>
>   ------------------------------------------------------------------------
>                   Name: att1.htm
>    att1.htm       Type: Hypertext Markup Language (text/html)
>               Encoding: base64
>            Description: Internet HTML
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ibiblio.org/pipermail/freetds/attachments/20000713/bd48b478/attachment.html 


More information about the FreeTDS mailing list