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 71231 - The Run File action does not work for SQL files
Summary: The Run File action does not work for SQL files
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
Depends on: 102081
  Show dependency tree
Reported: 2006-01-10 12:48 UTC by Andrei Badea
Modified: 2009-10-02 21:22 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description Andrei Badea 2006-01-10 12:48:29 UTC
According to the UI spec at

the Run File action should also work for SQL files (from the user's point of
view). Assuming a SQL editor is active, choosing Run - Run File - Run File from
the menu or pressing Shift+F6 should execute the SQL statement(s) in the editor.
Comment 1 Andrei Badea 2006-05-29 12:11:06 UTC
Still not possible now, but the new actions API which is being developed in
trunk will allow it.
Comment 2 Andrei Badea 2007-01-04 17:36:35 UTC
Postponing as issue 70280 has been postponed.
Comment 3 Andrei Badea 2008-08-04 12:59:02 UTC
Not fixable for 6.5.
Comment 4 Jiri Rechtacek 2009-02-10 15:14:21 UTC
Reassigned to new owner.
Comment 5 Petr Jiricka 2009-08-11 10:55:21 UTC
Now when issue 102081 is addressed, could this be implemented for NB 6.8? I would find this useful especially in the
following scenario: I receive a project, which contains instructions on how to create a database for this project.
Typically, there will be a .sql script which contains commands to create the db schema (CREATE TABLE...) and to populate
it with data (INSERT INTO...). The user needs to create a new database and populate it with this .sql script.

I should be able to run SQL files directly using Run File. Opening it in the SQL editor and running it from there is not
intuitive (I don't want to edit it, so why should I open it). I need to be able to run it not only against existing db
connection, I should be able to create a new connection (against existing database), or a new database in the process.
See also issue 170181 which suggests how to make "New Database" more prominent.
Comment 6 Jiri Rechtacek 2009-08-20 23:14:07 UTC
Comment 7 Quality Engineering 2009-08-21 17:52:57 UTC
Integrated into 'main-golden', will be available in build *200908211401* on (upload may still be in progress)
User: Jiri Rechtacek <>
Log: #71231: The Run File action  does not work for SQL files
Comment 8 Michel Graciano 2009-10-02 21:22:01 UTC
v. 200910010513