ALTR Driver JDBC Installation

Overview

The following information will walk you through the process of installing our JDBC driver for Java applications on any operating system. If your application is on Windows only, refer to ODBC Driver Installation.

Pre-Installation

After determining which driver you need, ALTR will provide you with the installer for it. Before installing the driver, you will need to acquire an installation key by adding an application on the ALTR Portal. Refer to Adding Applications for instructions. You will also need to enable TLS 1.2 on the machine where you’re installing the driver (if not already enabled).

Installing the JDBC Driver on Windows

To install the ALTR Driver on Windows, follow these steps:

1. Navigate to the directory containing ALTR JDBC Driver Installer.exe.
2. Double-click on ALTR JDBC Driver Installer.exe to launch the setup wizard.
3. Read the License Agreement, select 'I accept the agreement', and then click Next.
4. Enter your installation key and then click Next.
5. Click Browse, select the folder you would like to install the driver to, click OK, and then click Next.
6. Click Install.

To silently install the ALTR JDBC Driver via command prompt, follow these steps:

1. Click the Windows Start button, type cmd into the text box, and then press Enter.
2. In the command prompt, navigate to the directory where ALTR JDBC Driver Installer.exe is located:
   cd
3. Run the installer:
   ALTR JDBC Driver Installer.exe /silent /installationid

Installing the JDBC Driver on Linux

To install the ALTR JDBC Driver on Linux, follow these steps:

1. Launch the Linux terminal.
2. Extract the ALTR JDBC Driver archive.
3. unzip
4. Run the ALTR JDBC Driver Installer shell script.
5. bash altr_jdbc_installer.sh
6. Follow the prompts

Configure Application to use the ALTR JDBC Driver

Add the ALTR driver and dependencies to the application’s classpath. This may vary depending on how your application loads application JAR dependencies and how your application is deployed. In general, you must add the ALTR JDBC driver as an application dependency so that the application can properly load the driver.

Make the following changes to your application JDBC connection string to load the ALTR JDBC driver.

jdbc:altr:redshift://:5439/

In some cases, depending on how your application was developed, you may need to specify the following ALTR JDBC driver class name.

com.altr.jdbc.AltrDriver

‍

Add the ALTR driver and dependencies to the application’s classpath. This may vary depending on how your application loads application JAR dependencies and how your application is deployed. In general, you must add the ALTR JDBC driver as an application dependency so that the application can properly load the driver.

Make the following changes to your application JDBC connection string to load the ALTR JDBC driver.

jdbc:altr:redshift://:5439/

In some cases, depending on how your application was developed, you may need to specify the following ALTR JDBC driver class name.

com.altr.jdbc.AltrDriver

Troubleshooting

If you experience any issues during the installation process, please review the following list of possible errors and their solutions.

Invalid Installation Key
If you receive a message that the installation key is not valid during driver installation, make sure you are entering the correct installation key. If you continue to receive the message after confirming the installation key is correct, contact ALTR Support for assistance.

Unverified Installation Key
If you receive a message that the installation key cannot be verified during driver installation, make sure the Application’s public IP address is correct in the ALTR Portal. If the public IP address is incorrect and doesn't match the public IP address of the machine you're installing the driver on, update it and run the driver installer again. If you receive the message again, contact ALTR Support for assistance.

Query Log is Empty
If no queries appear in the Query Log after executing them in your application, make sure your application has been modified to use ALTR's driver. Refer to your application's user guide for further instructions.

‍

‍