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 167330 - ide hangs during database schema node refresh
Summary: ide hangs during database schema node refresh
Status: RESOLVED DUPLICATE of bug 155786
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-18 18:10 UTC by rptmaestro
Modified: 2009-06-23 15:58 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
messages.log (2.82 MB, text/plain)
2009-06-18 18:13 UTC, rptmaestro 		Details
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 rptmaestro 2009-06-18 18:10:33 UTC 
Every time I attempt to refresh a database schema node in the database explorer, the IDE hangs. My connection is an Oracle 
TNS connection.
Comment 1 rptmaestro 2009-06-18 18:13:02 UTC 
Created attachment 83770 [details]
messages.log
Comment 2 Marian Mirilovic 2009-06-22 10:50:16 UTC 
reassign to DB for evaluation ...
Comment 3 Petr Blaha 2009-06-22 12:34:12 UTC 
There are many following exceptions in log:
java.sql.SQLException: ORA-01031: insufficient privileges
java.sql.SQLException: ORA-01424: missing or illegal character following the escape character

It seems as the issue with credentials.
Comment 4 Jiri Rechtacek 2009-06-22 19:17:56 UTC 
I can confirm this problem in NB6.7RC3, it's caused by a broken connection (see tons of SQLException which came from
Oracle driver due to a problem on the database side). The fix of this problem has to make IDE more robust to outage on
server side (e.g. insufficient privileges, broken network, irresponsible database, ...) - it's a know problem in IDE -
documented in http://wiki.netbeans.org/DatabasePlan68 and will be subject of stabilization of DB tooling, just after
NB6.7 release.

*** This issue has been marked as a duplicate of 155786 ***
Comment 5 Jiri Rechtacek 2009-06-23 15:58:25 UTC 
*** Issue 167542 has been marked as a duplicate of this issue. ***