pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Anders Svensson <anders@simusoft.dk>
To: pgsql-interfaces@postgresql.org <pgsql-interfaces@postgresql.org>
Subject: Bug in JDBC driver V. 7.0 ?
Date: Thu, 20 Jul 2000 16:53:07 +0200
Message-ID: <p04320400b59cc0c69554@[130.228.196.18]> (raw)

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@simusoft.dk
tlf.	: +45 3583 8126



view thread (4+ messages)  latest in thread

Message-ID: <p04320400b59cc0c69554@[130.228.196.18]>
Permalink:  ../p04320400b59cc0c69554@%5B130.228.196.18%5D/
Also on:    postgresql.org/message-id/p04320400b59cc0c69554@[130.228.196.18]

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: anders@simusoft.dk
  Subject: Re: Bug in JDBC driver V. 7.0 ?
  In-Reply-To: <p04320400b59cc0c69554@[130.228.196.18]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox