getCatalogs() and getTables()

Stephanie Lewis slewis at thinweb.com
Fri Jul 14 08:12:23 EDT 2000


Yup,
        I'm using Service Pack 6. I installed a patch for it though long
before I started using the driver so I don't know what effect the patch
had on the driver's performance.

Edson Carlos Ericksson Richter wrote:

> Are you using NT 4 with Service Pack 6? I have ear someone with
> problems due to modifications made by Microsoft into TCP/IP stack in
> SP 6... Use NT 4 with SP 5 (Bad news: I think that you will need to
> reinstall all...). When I have some time, I'll try do these tests with
> NT4+SP6a Edson Richter
>
>      ----- Original Message -----
>      From: Stephanie Lewis
>      To: TDS Development Group
>      Sent: Thursday, July 13, 2000 11:15 AM
>      Subject: [freetds] Re: getCatalogs() and getTables()
>       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/20000714/7b04a79d/attachment.html 


More information about the FreeTDS mailing list