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 88097 - ORA-01031 error
Summary: ORA-01031 error
Status: RESOLVED DUPLICATE of bug 59535
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
: 106723 (view as bug list)
Depends on:
Blocks:
 
Reported: 2006-10-26 18:13 UTC by lstanfie
Modified: 2007-07-11 13:39 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 lstanfie 2006-10-26 18:13:44 UTC 
When using Netbeans 5.0 or 5.5 connected to an Oracle 9i database the error
message "Unable to read the database structure, connection broken; ORA-01031:
insufficient Privilege" is displayed if I try to expand any table shown in the
runtime window tree.  I am using the Oracle driver ojdbc14.jar. I can access the
data using view data or an sql query. Only expanding the table node to view the
columns causes the problem.  The problem does not occur using the Sun Studio
Enterprise 8 IDE or the JDeveloper from Oracle. Do you have a fix or a work around?
Comment 1 Peter Pis 2006-10-30 07:59:30 UTC 
Reassigning to "db" for evaluation.
Comment 2 Andrei Badea 2006-10-31 09:49:50 UTC 
Try if using a 10.x driver helps.
Comment 3 lstanfie 2006-11-14 17:36:11 UTC 
I tried all the v9 and v10 drivers available from Oracle with no success.
Further analysis revealed that granting the "analyze all" rights to my id solves
the column display issue. What is Netbeans doing that requires this right?
Comment 4 Andrei Badea 2007-01-03 16:16:25 UTC 
It is retrieving the indexes by calling DatabaseMetaData.getIndexInfo() and the
Oracle driver for some reason seems to call ANALYZE TABLE in order to gather
index statistics. You can find more information in issue 59535.


*** This issue has been marked as a duplicate of 59535 ***
Comment 5 Andrei Badea 2007-06-19 09:52:30 UTC 
*** Issue 106723 has been marked as a duplicate of this issue. ***
Comment 6 Andrei Badea 2007-07-11 13:39:44 UTC 
*** Issue 106723 has been marked as a duplicate of this issue. ***