Bug in JDBC driver V. 7.0 ?

From: Anders Svensson <anders(at)simusoft(dot)dk>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Bug in JDBC driver V. 7.0 ?
Date: 2000-07-20 14:53:07
Message-ID: p04320400b59cc0c69554@[130.228.196.18]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

When I call the method getTableTypes() in java.sql.DatabaseMetaData,
all that's returned is:

SYSTEM INDEX.

The code for org.posgresql.DatabaseMetaData suggest that I should get at least

/**
* Get the table types available in this database. The results
* are ordered by table type.
*
* <P>The table type is:
* <OL>
* <LI><B>TABLE_TYPE</B> String => table type. Typical types are "TABLE",
* "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY",
* "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
* </OL>
*
* @return ResultSet each row has a single String column that is a
* table type
*/

but not the one (only) I get returned

snip:

java.sql.ResultSet rs = dbmd.getTableTypes ();

while (rs.next())
System.out.println(rs.getString(1));

just to rule out a codeing problem

--
Simu Soft
v/Anders Svensson
Nørrebrogade 140, 4 th
2200 København N
e-mail : Anders(at)simusoft(dot)dk
tlf. : +45 3583 8126

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Mount 2000-07-20 14:56:48 RE: Bug in JDBC driver V. 7.0 ?
Previous Message Thomas Lockhart 2000-07-20 14:12:40 Re: TCL API