This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 34762 - postgreSQL driver no support to DatabaseMetadata
Summary: postgreSQL driver no support to DatabaseMetadata
Status: CLOSED DUPLICATE of bug 31238
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 3.x
Hardware: PC Windows ME/2000
: P1 blocker (vote)
Assignee: issues@db
URL: http://jdbc.postgresql.org
Keywords:
Depends on:
Blocks:
 
Reported: 2003-07-07 00:09 UTC by massimo
Modified: 2004-08-19 09:23 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description massimo 2003-07-07 00:09:41 UTC
When testing postgreSQL driver 7.3 in NetBeans 3.5, you get 
an error message saying:
"Internal test driver incomplete. The driver may not 
support the required DatabaseMetadata methods. Take a look 
at the Output Window for details."
The OutputWindow shows:
---------------------
Testing driver org.postgresql.Driver.
Warning: No tables were found. Check your database.
Warning: No views were found. Check your database.
Warning: No procedures were found. Check your database.
---------------------
Looks like something's wrong with the driver, which might 
not implement correctly DatabaseMetadata.

PostgreSQL version used is 7.3.3
JDBC driver is pg73jdbc3.jar (JDBC3) downloaded from 
http://jdbc.postgresql.org/download.html

Other than that driver works just fine: you can connect to 
a postgreSQL database, you can query, insert, update and 
execute any SQL command. Everything works fine except that 
the Database Explorer does not seem to be able to get the 
metadata out of the database. It does not show any node 
under the "tables", "procedures" and "views" nodes, 
although it is connected just fine to a non empty database.

Could not find any work around to show the subnodes (for 
that i set priority 1, no workaround available).

Same thing happens when using the TDS driver for Microsoft 
SQL server, but i will wait on some feedback on this one 
before opening another issue on the that driver as well.
Comment 1 Radko Najman 2003-07-08 13:39:51 UTC
It seems like a duplicate of #31238.

*** This issue has been marked as a duplicate of 31238 ***
Comment 2 dmladek 2004-08-19 09:23:39 UTC
confirming as a dup