Installing JDBC drivers

The general steps for installing JDBC drivers for use with CLC software are:

  1. Download the appropriate JDBC driver for your database system from the provider. Further details about this are provided below.
  2. Place the driver into the userlib directory in the installation area of the CLC Bioinformatics Database.
    • For a CLC job node setup, the JDBC driver file must be placed into the userlib folder under the CLC Bioinformatics Database installation area on the master node and also on each of the job nodes.
    • For a grid node setup, the driver file only needs to be placed into the userlib folder of the master CLC Bioinformatics Database installation area.
  3. Restart the CLC Bioinformatics Database software.
    • For a job node setup, restart the master server and each of the job nodes.
    • For a grid setup, only the master CLC Server needs to be restarted. This will cause the changes to be deployed to the grid workers.

Getting JDBC drivers

Information on obtaining JDBC drivers for supported DBMS systems is provided in this section. After obtaining the driver, the general instructions given above should be followed to complete the driver installation.

MySQL JDBC Drivers

  1. Go to http://dev.mysql.com/downloads/connector/j/ to download the driver.
  2. Choose the option Platform Independent when selecting a platform.
  3. After clicking on the button to Download, you can login if you already have an Oracle Web account, or you can just click on the link that says No thanks, just start my download further down the page.
  4. Uncompress the downloaded file and move the driver file, which will have a name of this form: mysql-connector-java-X.X.XX-bin.jar, to the folder called userlib, found in the installation area of the CLC Bioinformatics Database.

PostgrSQL JDBC Drivers

  1. Go to https://jdbc.postgresql.org/download.html and download the relevant driver.
  2. Place it in the folder called userlib, found in the installation area of the CLC Bioinformatics Database.

Microsoft SQL Server

  1. Go to https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server and download the relevant driver.
  2. Follow the installation instructions given for the driver to the point where the downloaded file has been unpacked.
  3. Move the driver jar file compatible with java 1.8 to the folder called userlib, found in the installation area of the CLC Bioinformatics Database.

Oracle JDBC Drivers

  1. Go to http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html.
  2. Select the relevant version for your Oracle database version.

    You will need an Oracle account to download the driver.

  3. Move the driver jar file to the folder called userlib, found in the installation area of the CLC Bioinformatics Database.