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 200808141419) VM: Java HotSpot(TM) Client VM, 10.0-b23, Java(TM) SE Runtime Environment, 1.6.0_07-b06 OS: Linux, 2.6.24-19-generic, i386 User Comments: Trying to update a value from result set table Stacktrace: java.lang.NullPointerException at org.openide.NotifyDescriptor$Exception.<init>(NotifyDescriptor.java:808) at org.netbeans.modules.db.dataview.output.SQLStatementExecutor.commitOrRollback(SQLStatementExecutor.java:143) at org.netbeans.modules.db.dataview.output.SQLExecutionHelper$3.finished(SQLExecutionHelper.java:325) at org.netbeans.modules.db.dataview.output.SQLStatementExecutor.run(SQLStatementExecutor.java:109) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Created attachment 67738 [details] stacktrace
BTW, the database was updated correctly.
Sorry... but the database was not updated, my mistake looking it, but the issue still valid. Regards
In general update does works for me, please let me know which database, table etc your are using. If you are not using sample database, let me know the create schema, you can get the create script (get from the context menu of dataview) and select the few rows and create insert script from the context menu. I will look into this if I can reproduce this.
I'm also able to reproduce this issue. Just tried to commit changes into MySQL server.
Thanks. I am using oracle and can't send the DB details. BTW, I can't reproduce it now, but happen sometimes. Regards
Roman, I just tried MySQL, and it did work as expected. I need reproducible steps for a given table and dataset. Please try again and let me know.
Hi, as http://wiki.netbeans.org/IssueLifeCycle#section-IssueLifeCycle-EvaluatingIssues, this issue should be marked as INCOMPLETE before closed as WORKSFORME
I did try various update use case on various databases, but I am not able to reproduce this.
OK, Since there is further information from the submitter, I am closing this as INVALID.
ahimanikya, can you report more details about it? This is a random problem and I have no reproducible steps. Regards
Before we were not checking validity of connection, now that we do that I guess we will no longer see these kind Random issues. Lets close this, when you see the same thing next time, please capture the steps and open a new issue.
I will mark as verified since I can't simulate it for latest builds. If necessary I reopen it in the future. Thanks
Thanks. Please do capture steps, in case you see this behavior again.
I reproduced this in the latest build 200810100201 with the following steps: 1.) Connect to MySQL Server from Netbeans 2.) Right-click on the MySQL Server and select Create Database 3.) From the dropdown, select Sample Database: vir and check grant full access to root@localhost and press OK 4.) In the connection to vir below, right-click employee table and press Add Column 5.) Give table name "major", keep type bit and press OK 6.) Expand employee table and right-click major and view data 7.) Change the <NULL> values to something and it will be changed to false 8.) Press the commit records icon and the exception is thrown
I just did as explained in the steps and it worked without any exception. Also this does not look like the same issue as reported earlier, so downgrading to P3, please send me the stacktrace.
Created attachment 71601 [details] Updated dataview screen.
It works for me based on the steps both in Windows and Mac.