Postgres Pro
Downloads
Home   >   mailing lists

Thread: JDBC

JDBC

From
"Enrico Comini"
Date:
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

Re: JDBC

From
"Peter Mount"
Date:
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
 
----- Original Message -----
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

Re: JDBC

From
Zeljko Trogrlic
Date:
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>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@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