Re: JDBC

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(at)retep(dot)org(dot)uk>peter(at)retep(dot)org(dot)uk,
> <mailto:me(at)petermount(dot)com>me(at)petermount(dot)com
> Homepage: <http://www.retep.org.uk>http://www.retep.org.uk Contact details:
> <http://petermount.com>http://petermount.com
> PostgreSQL JDBC:
> <http://www.retep.org.uk/postgres/>http://www.retep.org.uk/postgres/
> Java PDF Generator:
<http://www.retep.org.uk/pdf/>http://www.retep.org.uk/pdf/
>>
>> ----- Original Message -----
>> From: <mailto:algobit(at)algobit(dot)com>Enrico Comini
>> To: <mailto:Pgsql-General(at)Postgresql(dot)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(at)post(dot)hinet(dot)hr