Including JDBC Drivers for Connecting to SQL Databases

InstallAnywhere 2024 R2

The SQL database support in InstallAnywhere requires JDBC drivers for connecting to database servers. The drivers that are required vary, depending on the type of database that you are targeting.

Connecting to Microsoft SQL Server Databases and PostgreSQL Databases

When you are installing InstallAnywhere and you choose the Typical install set or you include the JDBC Drivers feature for the Custom install set, the installer installs drivers for connecting to some of the SQL databases that InstallAnywhere supports:

Drivers that Are Installed with InstallAnywhere by Default
Database	Driver	Default Location
Microsoft SQL Server	jTDS	Driver: $IA_HOME$/resource/db/drivers/jTDS License: $IA_HOME$/resource/db/drivers/jTDS/LICENSE.TXT
PostgreSQL	PostgreSQL JDBC	Driver: $IA_HOME$/resource/db/drivers/PostgreSQL License: $IA_HOME$/resource/db/drivers/PostgreSQL/LICENSE.TXT

The jTDS and PostgreSQL JDBC drivers are type 4 JDBC drivers. These drivers are platform independent. They are written in pure Java and communicate in the database systems’ built-in network protocols. InstallAnywhere includes those drivers as dependencies in your projects automatically when you add these database server hosts to your projects.

If you plan on targeting Microsoft SQL Server or PostgreSQL databases, ensure that you review the license for the driver that you plan on using to ensure that your distribution plans comply with the driver’s license requirements.

Connecting to DB2, MySQL, Oracle, and Other Databases

Because of licensing restrictions, InstallAnywhere does not provide the drivers for DB2, MySQL, or Oracle. Therefore, if you want to configure your projects to manage one or more of these types of SQL databases, you must obtain the appropriate drivers for these databases and add them to your projects.

In addition, InstallAnywhere includes a Generic JDBC Connection option—which is available as a database type—that you can choose if you want to target other types of databases.

To learn how to obtain the drivers for these database types and add them to your development machine for use with InstallAnywhere projects, see:

•

Obtaining DB2 Drivers

•

Obtaining a MySQL Driver

•

Obtaining an Oracle Driver

•

Obtaining a Generic JDBC Driver

Specifying JDBC Driver Information

To specify the JDBC driver information for a SQL database host in your project:

In the Advanced Designer, on the Organization page, click Hosts. The Hosts view opens.

In the Host List, click the database host that corresponds with the server that you want to configure.

Configure the settings that are displayed at the bottom of the view.

For details on how to configure the available settings, see Database Server Host Settings.

Tip:As an alternative, you can configure JDBC driver information when you click the database host in the Install view on the Sequence page.