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.
Build: NetBeans IDE Dev (Build 200904011705) VM: Java HotSpot(TM) Client VM, 1.5.0_16-133, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_16-b06-284 OS: Mac OS X, 10.5.6, i386 User Comments: GUEST: Following the Connecting to a MySQL Database tutorial (IDE 6.0 against IDE 6.5 beta); found a number of items that did not match. New interface was definitely easier than the tutorial steps. I was following the "Running an SQL Script" section of the tutorial. The first delete went fine, but when I deleted the subject table, it provoked the MySQLSyntaxException error. The UI shows the table removed from the Tables node. atellezflores: I have a store procedure that creates a temporary table (conalepsie.regpermisos), and after it finishes all processes drops that temporary table, inside MySQL QueryBrowser, no problems are reported by the tool, nor in Minq DBVisualizer Stacktrace: org.netbeans.modules.db.metadata.model.api.MetadataModelException: org.netbeans.modules.db.metadata.model.api.MetadataException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'timewhale_dev.users' doesn't exist at org.netbeans.modules.db.metadata.model.JDBCConnMetadataModel.runReadAction(JDBCConnMetadataModel.java:99) at org.netbeans.modules.db.metadata.model.api.MetadataModel.runReadAction(MetadataModel.java:89) at org.netbeans.modules.db.explorer.node.ColumnNode.setupNames(ColumnNode.java:122) at org.netbeans.modules.db.explorer.node.ColumnNode.refresh(ColumnNode.java:109) at org.netbeans.api.db.explorer.node.NodeProvider.refresh(NodeProvider.java:133) at org.netbeans.modules.db.explorer.node.NodeRegistry.refresh(NodeRegistry.java:136)
Created attachment 79999 [details] stacktrace
NB6.7 was released already - http://www.netbeans.org/community/releases/67/ Postpone fixing this issue on the next release.
*** Bug 173956 has been marked as a duplicate of this bug. ***
Created attachment 105949 [details] stacktrace Product Version: NetBeans IDE 7.0 Beta 2 (Build 201102111519) Java: 1.6.0_22; Java HotSpot(TM) 64-Bit Server VM 17.1-b03 System: Linux version 2.6.35-25-generic running on amd64; UTF-8; en_US (nb) During testing beta 2, while executing the task ysql_010, when executing the third command Create database, the exception was thown. ysql_010 1. Rightclick "Databases" node and choose "Register MySQL Server". 2. Specify valid basic properties for MySQL server, but with user, who hasn't admin privilegies, and click "OK". 3. Rightclick MySQL server node and choose "Create Database...". 4. Choose database "sample" and click OK. Expcected: Message that user aren't granted should appear. Actual: Exception thrown
Created attachment 105950 [details] stacktrace Databases Integration Test Specification http://qa.netbeans.org/modules/webapps/promo-h/DBIntegration.html work_mysql_010 Create standard DB with user, who hasn't admin privilegies 1. Rightclick "Databases" node and choose "Register MySQL Server". 2. Specify valid basic properties for MySQL server, but with user, who hasn't admin privilegies, and click "OK". 3. Rightclick MySQL server node and choose "Create Database...". 4. Choose database "sample" and click OK. Expected: Message that user aren't granted should appear. Actuall: At step 3. exception is thrown
Created attachment 107015 [details] stacktrace When trying to create a new database with a user without admin privileges. Based uppon test specification below : 1. Rightclick "Databases" node and choose "Register MySQL Server". 2. Specify valid basic properties for MySQL server, but with user, who hasn't admin privilegies, and click "OK". 3. Rightclick MySQL server node and choose "Create Database...". 4. Choose database "sample" and click OK.
Still reproducible in NB7.0RC1. MySQL Registration dialog asks for user who has the administrator role, but IDE should be robust enough to handle this scenario.
core-main/rev/e1273293cbbb
Integrated into 'main-golden', will be available in build *201103300400* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main/rev/e1273293cbbb User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #162530: [67cat] com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'timewhale_dev.users' doesn't exist
*** Bug 195404 has been marked as a duplicate of this bug. ***