This section describes how to setup connections and how the plugin manages this connections.
This plugin uses JDBC to connect a database therefore its necessary that a JDBC driver can be found by the plugin.
The JDBC driver can either be installed by copying all the driver JAR file(s) into lib directory of the plugin (
The message 'No suitable driver.' is displayed if the plugin couldn't locate a driver for the current connection setup.
The connections are setup in the plugins settings dialog () » Connections panel. Currently the setup connections can only be used in the current project. It is planned to support connections which can be used from all projects in the future.
The plugin provides support for the creation of the JDBC URL, the management of the connection properties and the location of the driver class for some JDBC drivers of most common databases: These databases include:
It's also possible to connect to others than the supported drivers but the user has to enter the driver class name and the JDBC URL by himself.
The plugin opens maximal 2 connections for every connection configuration. This means that 2 SQL statements which are execute in different panels are using the same connection.
The first connection is used to execute all the statements and a second connection is used to get necessary database meta data.