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
-
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.
-
Copy the relevant driver file for your database management system to the toolkit\configuration\environment\common\jdbc-drivers directory.
-
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"
.