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 153575 - DELETE SQL Statements do not execute
Summary: DELETE SQL Statements do not execute
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: Macintosh Mac OS X
: P3 blocker (vote)
Assignee: davidc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-20 19:41 UTC by hexghost
Modified: 2008-12-22 10:40 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description hexghost 2008-11-20 19:41:28 UTC
When I use the "execute sql command" feature to run sql queries on a database, DELETE statements are not executed. I don't get an error message or 
anything, there just doesn't appear to be anything happening. SELECT statements work fine. If I right click on the database and select properties, "read only" is 
not turned on. 

This database connection was imported from when I was using 6.0, and delete statements worked fine then.
Comment 1 David Vancouvering 2008-11-20 20:12:25 UTC
I can't reproduce this. I used Java DB, connected to the sample database, and I ran the following:

select * from APP.CUSTOMER;

DELETE FROM APP.CUSTOMER WHERE CUSTOMER_ID = 2;

select * from app.customer;

I got two result tabs as as a result.  The first result tab shows customer id 2, the second one doesn't.  The output
shows the following:

Executed successfully in 0.004 s.
Line 1, column 1

Executed successfully in 0.011 s, 1 rows affected.
Line 3, column 1

Executed successfully in 0.011 s.
Line 5, column 1

Execution finished after 0.026 s, 0 error(s) occurred.

Can you provide more information so we can try and reproduce?

Thanks!

David
Comment 2 Roman Mostyka 2008-11-24 16:24:04 UTC
hexghost, can You update this issue since we can't work on it because we don't have enough info.
Comment 3 Roman Mostyka 2008-12-22 10:33:23 UTC
There is no update during a month, so probably this issue was fixed with another fix.
I close this issue.
Comment 4 Roman Mostyka 2008-12-22 10:40:11 UTC
Verified.