SQooLer tutorial

Set up your database connection

After you installed SQooLer switch to SQooLer perspective. You have to open the connections view (if not opens automatically). (Windows -> Show view -> Others -> SQooLer -> Connections)

Now in the view's context menu click on "Add connection...". You will see the connection wizard. Fill out!:-)

To connect to your database you have to click on "Connect" in the context menu.

Connection wizard

The SQooLer perspective

Now create a simple project (e.g. "scripts"), and a simple file (e.g. "test.sql"). The file name must have the extension "sql".

You have to see your project in "Navigator" and your "test.sql" in an editor, and there is a view under the editor called SQooLer.
You have six tool items in the toolbar if your editor is active:

  • Run statement
  • Cancel statement
  • Commit
  • Rollback
  • Connection combobox
  • Updatable select

  • sqooler_1

    Run your first statement

    If you successfully connected to your database, you can see informations about in the SQooLer view, or error messages if the connecting is failed.

    Now you can write your statement in the "test.sql" (SELECT * FROM test), and click on "Run", or press "F9". The result appears in the table in SQooLer view.


    Tips & Tricks

  • If you have more then one statement in the editor, select the one you want to run, or separate them with ";".

  • There is an information icon in the toolbar of SQooLer view. You can see some properties of your database and JDBC driver.

  • Double click on a cell in the table opens a data viewer dialog

  • or

  • in "updateable" mode a viewer is editable and updates your selected field.

  • You can configure your own hotkeys in Window -> Preferences -> Workbench -> Keys. You have to choose the category "SQooLer Actions".

  • There is a "properties" directory contains several text files in the plugin directory. You can modify theese files as you wish:
  • "content.properties": this file contains keywords for the content assist, and can contain help texts, too. E.g.:
    SELECT=SELECT [DISTINCT] {select-item...
  • "datatypes", "plsql", "sql_functions", "sql_keywords", "sql_statements": theese files contain words for syntax-highlighting.
  • alttext
    Tutorial to older versions