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.
| Summary: | java.sql.SQLException: ORA-00942: table or view does not exist | ||
|---|---|---|---|
| Product: | db | Reporter: | pecas <pecas> |
| Component: | DB schema | Assignee: | Jiri Rechtacek <jrechtacek> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | blocker | CC: | dbadaniel, jkilgrow, misterm, pecas |
| Priority: | P3 | ||
| Version: | 6.x | ||
| Hardware: | All | ||
| OS: | Windows XP | ||
| URL: | http://statistics.netbeans.org/exceptions/detail.do?id=132815 | ||
| Issue Type: | DEFECT | Exception Reporter: | 132815 |
| Attachments: |
stacktrace
stacktrace stacktrace |
||
Created attachment 75277 [details]
stacktrace
Build: NetBeans IDE 6.5 Beta (Build 200808111757)
VM: Java HotSpot(TM) Client VM, 1.5.0_10-b03, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_10-b03
OS: Windows XP, 5.1, x86
User Comments:
Stacktrace:
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
Created attachment 75385 [details]
stacktrace
Reassigned to new owner. Is it still a problem? Could you attach steps to reproducing this problem? Thanks Build: NetBeans IDE 6.5 (Build 200811100001)
VM: Java HotSpot(TM) Client VM, 10.0-b19, Java(TM) SE Runtime Environment, 1.6.0_04-b12
OS: Windows XP, 5.1, x86
User Comments:
Error while expanding node. Prevents any info about table from being displayed
Stacktrace:
org.netbeans.api.db.explorer.DatabaseException: java.sql.SQLException: ORA-01031: insufficient privileges
at org.netbeans.modules.db.explorer.infos.TableNodeInfo.initChildren(TableNodeInfo.java:172)
at org.netbeans.modules.db.explorer.infos.TableNodeInfo.initChildren(TableNodeInfo.java:78)
at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.loadChildren(DatabaseNodeInfo.java:765)
at org.netbeans.modules.db.explorer.infos.DatabaseNodeInfo.getChildren(DatabaseNodeInfo.java:753)
at org.netbeans.modules.db.explorer.nodes.DatabaseNode$DatabaseNodeChildFactory.createKeys(DatabaseNode.java:382)
at org.openide.nodes.AsynchChildren.run(AsynchChildren.java:147)
Created attachment 78827 [details]
stacktrace
Steps to reproduce using Oracle: 1. Create any number of tables for user A; 2. Create public synonyms for them and grant select, update, delete and insert permissions to user B, a regular user; 3. Connect in NB using B; 4. Expand the node for the tables created in step 1. The bug seems to be obsolete. @misterm: your case is an another than the original. Please, file it again with NB6.8 in best. Thanks |
Build: NetBeans IDE 6.5 Beta (Build 200808111757) VM: Java HotSpot(TM) Client VM, 1.5.0_10-b03, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_10-b03 OS: Windows XP, 5.1, x86 User Comments: pecas: I need recapture schema from DataBase joostnufan: refresh DATABASE Schema pecas: I need recapture schema from DataBase Stacktrace: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)