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 - Provide API to allow execution of SQL without having to open a SQL editor
Summary: Provide API to allow execution of SQL without having to open a SQL editor
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: Macintosh All
: P2 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks: 134307
  Show dependency tree
 
Reported: 2008-07-02 01:39 UTC by David Vancouvering
Modified: 2008-07-14 19:33 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.