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 138768

Summary: Provide API to allow execution of SQL without having to open a SQL editor
Product: db Reporter: David Vancouvering <davidvc>
Component: SQL EditorAssignee: David Vancouvering <davidvc>
Status: VERIFIED FIXED    
Severity: blocker CC: romanmostyka
Priority: P2    
Version: 6.x   
Hardware: Macintosh   
OS: All   
Issue Type: ENHANCEMENT Exception Reporter:
Bug Depends on:    
Bug Blocks: 134307    

Description David Vancouvering 2008-07-02 01:39:13 UTC 
Currently the only way you can execute a SQL script within the context of the DB explorer is to open a SQL file and then
tell it to execute.  This results in a lot of overhead that isn't needed if you just want to execute the SQL and be done
with it.  This overhead will be even higher once we integrate the DataView module.

This issue proposes an enhancement to the db.core friend API where you can simply execute the SQL and get the status of
executing each statement (e.g. SELECT statements do not provide results to the caller).
Comment 1 David Vancouvering 2008-07-02 01:39:45 UTC 
Sakila database support needs this feature
Comment 2 David Vancouvering 2008-07-10 17:52:12 UTC 
http://hg.netbeans.org/main?cmd=changeset;node=cbfb95269dd6
Comment 3 Roman Mostyka 2008-07-14 19:33:24 UTC 
Verified with build 080714.