Installing database drivers in your Web application server - 6.5

Talend Data Management Platform Installation Guide for Linux

EnrichVersion
6.5
EnrichProdName
Talend Data Management Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

If you are not using the embedded H2 database with Talend Administration Center or Talend Activity Monitoring Console, you must install the driver for the database to use in your Web application server.

For more information regarding the databases compatible with Talend Administration Center and Talend Activity Monitoring Console, see Compatible databases.

Procedure

  1. Stop your Web application server.
  2. In case you use Tomcat, clean the <apache-tomcat>/work/Catalina/localhost folder.
  3. Make sure that the driver for the database you want to use does not exist in any of the following folders. If the driver already exists in one of these folders, skip the next step.

    Web application Server used

    Folders to check

    Tomcat

    <apache-tomcat>/webapps/amc/WEB-INF/plugins/org.talend.amc.libraries_vA.B.C.YYYYMMDD_HHmm/lib/ext

    JBoss

    <JBoss_installation_folder>/standalone/lib/ext

    <JBoss_installation_folder>/standalone/lib/endorsed

    <JBoss_installation_folder>/standalone/tmp/work/jboss.web/default-host/amc/eclipse/plugins/org.talend.amc.libraries_X.X.X.XXXXXXXX_XXXX/lib/ext

  4. Download the correct database driver(s) from the official provider website, according to the version of the JVM you use to run your Web application server and the version of the database you want to use.
    In case you use Oracle, use a copy of the ojdbcX.jar file from your Oracle installation.
    Note that those drivers are specific and that you should only download the one(s) that you need.
    Database used Driver to download
    Azure SQL Download the patched jTDS driver from https://sourceforge.net/p/jtds/bugs/_discuss/thread/16113049/7594/attachment/jtds-1.3.1.jar.

    For more information about the related bug, see https://sourceforge.net/p/jtds/bugs/725/?page=0. Note that there is no official release that includes the fix yet.

    MySQL http://dev.mysql.com/downloads/connector/j/
    Oracle http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
    MS SQL http://sourceforge.net/projects/jtds/files/jtds/
    PostgreSQL http://jdbc.postgresql.org/download.html
    Microsoft JDBC Drivers 6.0, 4.2, 4.1, and 4.0 for SQL Server http://www.microsoft.com/en-us/download/details.aspx?id=11774
    MariaDB https://downloads.mariadb.org/connector-java/
  5. It it does not exist, create the driver folder.
    • For Tomcat, create a new endorsed folder under <apache-tomcat>.
    • For JBoss, create a new ext folder under <JBoss_installation_folder>/standalone/tmp/work/jboss.web/default-host/amc/eclipse/plugins/org.talend.amc.libraries_X.X.X.XXXXXXXX_XXXX/lib/.
  6. Place the driver(s) you need in the folder you created.
    • In the folder you created for Apache Tomcat 8.0 and JBoss.
    • In <apache-tomcat>/lib for Apache Tomcat 8.5.
  7. In case you install the patched jTDS driver to work with Microsoft Azure database, in the database settings of Talend Administration Center fill in the information of the patched driver as follows:
    database.url=jdbc:jtds:sqlserver://talendtac.database.windows.net:1433/tac;user=tadmin@talendtac.database.windows.net;password=yourpassword;ssl=require;
    database.driver=net.sourceforge.jtds.jdbc.Driver
    database.username=tadmin
    database.password=yourpassword

    ssl=require is a mandatory parameter, as stated in the Microsoft documentation: https://docs.microsoft.com/nl-nl/azure/sql-database/sql-database-develop-java-simple#Opmerking.

  8. Restart your Web application server.