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 (
IDEA 4.5: ${user.home}/.IntelliJIdea/config/plugins/ks-sql/lib ;
IDEA 5.0: ${user.home}/.IntelliJIdea50/config/plugins/ks-sql/lib )
or specifying the directory containing the
JAR file(s) in the plugin settings dialog ( )
» Miscelleanous » Drivers panel.
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:
- Oracle
- Microsoft SQL Server
- DB2
- MySQL
- PostgreSQL
- Sybase
- Informix
- HSQLDB
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.
By default all connections are closed if the plugin toolwindow is closed. You can turn off this feature in the
plugins setting dialog ( ) »
Miscelleanous » Connections panel.
|