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 132100 - Unable to browse Oracle tables
Summary: Unable to browse Oracle tables
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-04-04 18:58 UTC by munseym
Modified: 2008-04-09 00:38 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description munseym 2008-04-04 18:58:37 UTC 
This seems to be similar to Issue 100025, which is closed.  When using Oracle JDBC, using the ojdbc14.jar driver,
oracle.jdbc.OracleDriver driver, I can't browse the tables in the Netbeans Services window.  I am able to connect to the
database and run queries if I know the table names, but I can't browse them.
Comment 1 David Vancouvering 2008-04-07 23:56:41 UTC 
Can you try this with the latest NetBeans 6.1 nightly build (see
http://bits.netbeans.org/download/trunk/nightly/latest/)  and see if this is still an issue?  I made some changes that I
think should have fixed this issue.
Comment 2 David Vancouvering 2008-04-08 18:59:42 UTC 
Marking as incomplete, waiting to hear if latest 6.1 fixes the problem.
Comment 3 munseym 2008-04-08 23:50:52 UTC 
The 6.1 nightly build didn't seem to change anything for me, but I did discover the problem.  I found that I need to not
accept the default schema (my username), but instead use the name of the owner of the table.  When I made that change,
the tables are shown.

The 'Grab Structure' and 'Properties' links return DatabaseException: ORA-01031: insufficient privileges.  I would like
to see a feature similar to the MyEclipse Database Explorer 'Generate DDL' so I can get specific information about
constraints, comments, etc.  I don't see a way to do that in NetBeans, but that isn't really a defect.
Comment 4 David Vancouvering 2008-04-09 00:38:29 UTC 
Thanks, munseym.  Yes, generate DDL is on our list of things to do, I *hope* to get to it in the next release, but it's
definitely on our radar.