/
Technical Reference Document: Driver Support

Technical Reference Document: Driver Support

JDBC Database Driver Files

If Andi finds database drivers on your local system, it will automatically register the driver for you. You can also copy the driver to the Andi/connections/drivers/ directory and if the driver is recognized it will be registered. Note: all jars must be present as listed below.

 

It is important to download a driver version which is compatible with and supported by your database. Drivers may support either a Type 2 and / or a Type 4 connection. For more details, refer to the documentation for your specific database or contact your Database Administrator. 

JDBC Type 4 URL

The JDBC type 4 driver or Thin driver is a pure Java URL that only requires one or more JAR files, not a complete client installation of the driver to communicate to a database. A server port and database name was added to the URL to allow the driver to communicate directly to the database, without the need of additional configurations on the clients system.

jdbc:<databaseType>://<serverName>:<serverPort>/<databaseName>

 

DB2

 

File

Description

db2jcc.jar

JDBC Support

db2jcc_license_cu.jar

The license which must be included.

 

Oracle

Choose one of the following jars depending on the version of your database.

 

File

Oracle Version

ojdbc6.jar

11.2 or 11gR2

ojdbc7.jar

12.1 or 12cR1

ojdbc8.jar

12.2, 12cR2, 18c

 

The following two jars are required for Andi advanced XML support.

 

File

Description

xdb6.jar

Classes to support standard JDBC 4.x java.sql.SQLXML interface.

xmlparserv2.jar

XML parsing support.

 

 

MySQL

The following jar provides JDBC support, you must however find the version which matches the database you want to connect with.

 

File

Description

mysql-connector-java-<version-number>-bin.jar

Use the jar version which matches your database.

 

SQLServer

There are a range of drivers to choose from. For more information refer to SQL Server or Azure SQL Database drivers. 

Choose one of the following jars depending on the version of your JVM (Java Virtual Machine).

 

File

JVM Version

mssql-jdbc-6.4.0.jre8.jar

8

mssql-jdbc-6.4.0.jre9.jar

9

SQL Server Windows Authentication

For more information refer to the SQLServer System Requirements for JDBC

Example Configuration

  1. Locate the sqljdbc_auth.dll file.

  2. Add -Djava.library.path=<fullyQualifiedPath> to where the "sqljdbc_auth.dll" is located to the Andi.vmoptions file which can be found in the Andi installation directory. The default Windows directory is \users\<userid>\JReflectionsLLC\Andi\

  3. Create the JDBC URL, in the following example replace the values within <>.

    • jdbc:sqlserver://<hostName>:<port>; databaseName=<databaseName>; IntegratedSecurity=true; User=<domain>\<userid>

DataDirect

Note: When using a DataDirect driver, you must include the ResultSetMetaDataOptions=1 connection parameter as it provides Andi with fully qualified column names. This is used extensively to enable XML update features, as well as in the Andi University sample database to fully qualify joined tables.