Installing Database Connectivity Drivers

In this section:

The Java Database Connectivity (JDBC) API is used for connecting to databases. JDBC drivers are available for most database engines and are distributed as a component of the database engine or separately as connectivity components. The licensing terms do not always allow distribution of these drivers with iWay products. Therefore only a basic set of drivers for the most common databases is shipped. You may download and install additional drivers on your own.

The following drivers are shipped with the product and are located in the runtime/ lib/jdbc subfolder of the product installation folder.

Apache Derby. JDBC driver for the Apache Derby database.
HSQLDB. JDBC driver for the HSQLDB database.
IBM DB2. JDBC driver for the IBM DB2 database.
jTDS. jTDS open-source driver for connecting to both MS SQL and Sybase servers.
Oracle. JDBC driver version 11g for Oracle databases.
Microsoft SQL Server. JDBC driver for Microsoft SQL Server 2000, SQL Server 2005, and SQL Server 2008. Requires JRE version 1.6.
PostgreSQL. JDBC driver for the PostgreSQL database. Supports PostgreSQL 7.3 or newer.
Teradata. JDBC driver version 13.10.00.18 for Teradata databases.

Top of page

Installing Drivers in the Application GUI

The drivers shipped with your product are installed automatically when the GUI is started for the first time. Additional drivers may be installed with the following process.

Top of page

Procedure: How to Install Drivers in the Application GUI

Download the required driver (usually an archive).
Extract the archive to a desired location.
Go to Window > Preferences > [Your Product] > Database.
In case of a pre-configured driver (for example, MySQL) double-click it.
In case you want to add a new database driver, click Add and provide the name of the new database.
Click Add to Classpath and locate the .jar driver in the extraction folder.
Click OK to finish.
The driver will have a green dot and YES in the Configured column of the table.

Top of page

Installing Drivers with a Standalone Product Core

When you use the product core without the GUI, all JDBC drivers (including those shipped with the product) must be installed before they can be used by the engine. A driver can be installed to the Core by copying its .jar file (located at [PRODUCT INSTALLATION FOLDER]/runtime/lib/jdbc/[database folder]) to [PRODUCT INSTALLATION FOLDER]/runtime/lib.

iWay Software