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.
When I execute a bulk 'update' SQL statement on a table that contains more than 20 rows, it appears to only update the first page of 'results'. For example, if I have a table 'USER', which has a column 'ENABLED', and I want to disable all of the users, I might execute the following query: update USER set ENABLED = 0 The intention here is to update every row in the table. If I have 100 rows, however, I receive the following response: Executed successfully in 0.094 s, 21 rows affected. Line 1, column 1 At first, the table looks correct when I view the data, because I'm shown the first 20 entries, but if I go to page 2 of the results, I start to see that the values are unchanged. This is occurring on SQL Server 2005, with the Microsoft JDBC driver.
Reassigned to new owner.
*** This issue has been marked as a duplicate of 157022 ***