Specifying the JDBC driver

The application server requires a JDBC driver to enable communication with the database. The JDBC driver that you provide to the deployment toolkit depends on the database management system to use with the deployment.

Procedure

  1. Locate the JDBC driver for your database management system.
    • If you are using Db2®, locate the IBM\SQLLIB\java\db2jcc4.jar file.
    • If you are using SQL Server with the Information Store, download the Microsoft JDBC Driver 7.4 for SQL Server archive from https://www.microsoft.com/en-us/download/details.aspx?id=58505. Extract the contents of the download, and locate the sqljdbc_7.4\enu\mssql-jdbc-7.4.1.jre8.jar file.
    • If you are using SQL Server with the Analysis Repository, download the Microsoft JDBC Driver 6.0 for SQL Server from https://www.microsoft.com/en-us/download/details.aspx?id=11774. Extract the contents of the download, and locate the sqljdbc_6.0\enu\jre8\sqljdbc42.jar file.
    • If you are using Oracle 12c Release 1, locate the jdbc\lib\ojdbc7.jar file.
    • If you are using Oracle 12c Release 2, locate the jdbc\lib\ojdbc8.jar file.
  2. Copy the relevant driver file for your database management system to the toolkit\configuration\environment\common\jdbc-drivers directory.
  3. If you are using Oracle, or you want to use a JDBC driver .jar file that has a custom name, you must add the jdbc-driver attribute to the <database> element in your topology.xml file.
    For example:
    <database dialect="oracle" xa="false" instance-name=""
        database-type="WriteStore" id="write1" host-name=""
        port-number="1521" jdbc-driver="jdbc_file_name.jar" />
    jdbc_file_name is the name of the .jar file to locate in the toolkit\configuration\environment\common\jdbc-drivers directory to use for the deployment.

    If you are using Oracle 12c Release 2, set the value as follows: jdbc-driver="ojdbc8.jar".


© Copyright IBM Corporation 2012, 2020.