Plugins→Plugins Options→SQL. Go
to the JDBC page and use the Add
Element button to indicate the path(s)
to the JDBC drivers you want to make
known to the program. At the time
of this writing, SQL can work with
Oracle, MySQL, PostgreSQL, Firebird,
DB2, Progress, MS SQL Server 2000,
Sybase and Teradata, assuming you
have the requisite JDBC drivers. This
previous step “registers” the database
so it can be used in the next step.
The next step is to configure a specific database (or maybe more than
one) with a project. This is where
Figure 5. SQL Plugin Returning a Result Set
Project Viewer comes in. You use it to
create the project (more detail on that
later). For now, I will use the project
that is this article. From the project
pane, right-click on the project name
and select properties. This will lead to
a series of dialogs that allow you to
fill in the needed information (Figure
4). In this case, I am using the Pagila
demo database for Postgres. From a
jEdit buffer, you now have access to
the database (Figure 5). There is quite
a bit going on there, so let’s take it a
step at a time.
Just above the buffers is the SQL
WWW.LINUXJOURNAL.COM SEPTEMBER 2011 | 117
