JDBC

The problem seems to be on how JBuilder is asking JDBC for the list of tables. It's on my list of things to check, although it's difficult without a copy of JBuilder (with the database components) to play with.

Peter

--
Peter T Mount peter@retep.org.uk, me@petermount.com
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: Enrico Comini
To: ML-Postrges-general
Sent: Monday, September 04, 2000 4:57 PM
Subject: [GENERAL] JDBC

HI,

I'm having a strange problem connecting to postgres 7.02 using the
jdbc driver. After installing the driver in Jbuilder 3, I'm able
to connect to my database but can ONLY see the postgres system indexes
in Jbuilder's JDBC Explorer GUI. I'm unable to see my other database
objects (tables, views, etc...) in the JDBC Explorer. Yet the
driver lets me manipulate these unseen objects when I execute sql
statements against the database. Problem is, I'd like to see all my
database objects in the JDBC Explorer GUI, not just the system index.

Has anyone experienced this who can suggest a fix? Does anyone
know if this is due to Jbuilder, the postgresql.Driver, or perhaps a
bad configuration? Thanks.

ENRICO

The problem could be in incorrectly implemented getTables.

PostgreSQL JDBC returns null. It's not defined that this column may be null,
like TABLE_CAT and TABLE_SCHEM. Actually, it returns just names, null for
everything else and "no remarks" for remarks.

From JDBC documentation:

4. TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM
TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

The second problem is that getTables returns index names, too, and it probably
shouldn't, I'm not sure how is that specified.

At 11:57 5.9.2000 , Peter Mount wrote:

The problem seems to be on how JBuilder is asking JDBC for the list of
tables. It's on my list of things to check, although it's difficult without a
copy of JBuilder (with the database components) to play with.

Peter

--
Peter T Mount <mailto:peter@retep.org.uk>peter@retep.org.uk,
<mailto:me@petermount.com>me@petermount.com
Homepage: <http://www.retep.org.uk&gt;http://www.retep.org.uk Contact details:
<http://petermount.com&gt;http://petermount.com
PostgreSQL JDBC:
<http://www.retep.org.uk/postgres/&gt;http://www.retep.org.uk/postgres/
Java PDF Generator:

<http://www.retep.org.uk/pdf/&gt;http://www.retep.org.uk/pdf/

----- Original Message -----
From: <mailto:algobit@algobit.com>Enrico Comini
To: <mailto:Pgsql-General@Postgresql.org>ML-Postrges-general
Sent: Monday, September 04, 2000 4:57 PM
Subject: [GENERAL] JDBC

HI,

I'm having a strange problem connecting to postgres 7.02 using the
jdbc driver. After installing the driver in Jbuilder 3, I'm able
to connect to my database but can ONLY see the postgres system indexes
in Jbuilder's JDBC Explorer GUI. I'm unable to see my other database
objects (tables, views, etc...) in the JDBC Explorer. Yet the
driver lets me manipulate these unseen objects when I execute sql
statements against the database. Problem is, I'd like to see all my
database objects in the JDBC Explorer GUI, not just the system index.

Has anyone experienced this who can suggest a fix? Does anyone
know if this is due to Jbuilder, the postgresql.Driver, or perhaps a
bad configuration? Thanks.
ENRICO

v
Zeljko Trogrlic
____________________________________________________________

Aeris d.o.o.
Sv. Petka 60 b, HR-31000 Osijek, Croatia
Tel: +385 (31) 53 00 15
Email: mailto:zeljko@post.hinet.hr