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 172301 - java.sql.SQLException: View 'quiz.question_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Summary: java.sql.SQLException: View 'quiz.question_view' references invalid table(s) ...
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL: http://statistics.netbeans.org/except...
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-15 15:36 UTC by Martin Schovanek
Modified: 2009-09-21 09:12 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter: 152321

Attachments
stacktrace (2.91 KB, text/plain)
2009-09-15 15:36 UTC, Martin Schovanek 		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 Martin Schovanek 2009-09-15 15:36:02 UTC 
Build: NetBeans IDE Dev (Build 200909140908)
VM: Java HotSpot(TM) 64-Bit Server VM, 14.1-b02-92, Java(TM) SE Runtime Environment, 1.6.0_15-b03-226
OS: Mac OS X, 10.5.8, x86_64

User Comments:
mschovanek: After execution of a .sql .



Stacktrace: 
java.sql.SQLException: View 'quiz.question_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
Comment 1 Martin Schovanek 2009-09-15 15:36:08 UTC 
Created attachment 87704 [details]
stacktrace
Comment 2 Jiri Skrivanek 2009-09-16 08:17:52 UTC 
Please, add steps to reproduce.
Comment 3 Jiri Skrivanek 2009-09-21 09:12:17 UTC 
No response from reporter.