Connections
 

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.


Installation of JDBC Driver

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.


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.


Connection Management

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.