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 # : 200903212112 ] [ JDK VERSION : 1.6.* ] steps: 1) Goto services explorer and add ms sql server 2005 driver and connect to ms sql server 2008 2) insert more that 25000 record to a selected table 3) now try to delete those record using a starts wilt expression ex: delete from <schema.table_name> where <table_name.field_name> like @value + '%'; 4) it deletes record and shows the command executed successfully but it only deletes about 20 to 30 record only; you have to keep executing this statement to delete the filtered dataset then i tried to delete all the data in this table using delete from <schema.table_name> but the same this happened. 5) then i performed step 4 in the ms sql server 2008 console and the delete from <schema.table_name> where <table_name.field_name> like @value + '%'; query executed successfully by deleting all the filtered records.
I don't understand the problem. If I delete records in a table in SQL editor, it applies on all records conforming my condition and removed all of them. Are you using SQL editor too? Or you are using some embedded language editor, a PHP perhaps? Why did you set P2 priority? IMHO it's doesn't conform http://wiki.netbeans.org/BugPriorityGuidelines
>>I don't understand the problem. If I delete records in a table in SQL editor, it applies on all records conforming my condition and removed all of them. follow the steps again here i have tried to delete 30000 records in a remote database(ms sql server 2008) where i wanted to delete records that starts with some string text(ex:'LTEST') and when i performed the delete the execution window states executed successfully but when i again query that same db table only about 20 records are deleted from those records and i had to execute the delete command for n number of times but i went to the remote server where the db server is and from its sql editor i executed the same query and it deleted all the matching string text records from the database. >>Are you using SQL editor too? Or you are using some embedded language editor, a PHP perhaps? i used the netbeans sql editor where i got this bug >>Why did you set P2 priority? IMHO it's doesn't conform Product feature doesn't work, a workaround exist but it's difficult to use or impractical (you can manually delete from db server editor) but you have to always log into the remote server to do this
Reassigned to new owner.