1. Server Manager Guide
  2. Obtain JDBC Drivers

Obtain JDBC Drivers

Tip: Web-Based Servers. Although not absolutely required, the sequence of installing JDBC drivers on your Management Console machines should precede the installation of any JD Edwards EnterpriseOne web-based server. This sequence is recommended because the process of installing JD Edwards EnterpriseOne web-based servers includes starting the server after the installation is complete. If the requisite JDBC driver is not installed, the JD Edwards EnterpriseOne web-based server cannot communicate with the JD Edwards EnterpriseOne Security Server thus the server cannot start.

Server Manager allows you to centrally manage JDBC drivers that are required to enable the various web-based servers to access their respective databases. Using Server Manager you can upload and install any of these JDBC drivers supported by the JD Edwards EnterpriseOne web-based servers:

  • Oracle Database

  • MicroSoft SQL Server

  • IBM DB2 for Windows or Unix

  • IBM DB2 for IBM i

You should obtain the required driver files from the database vendor. Once all the required files have been obtained they can be uploaded to the management console. This table lists the requisite JDBC drivers.

Database

JDBC Driver Files

Oracle 9i

classes12.jar

Oracle 10g (JDK 1.4)

ojdbc4.jar

Oracle 11g (JDK 1.5)

ojdbc5.jar

Oracle 11g (JDK 1.6)

ojdbc6.jar

Oracle 12c (JDK 1.7)

ojdbc7.jar

Oracle 12c/19c (JDK 1.8)

ojdbc8.jar

SQL Server (JDK 1.4/JDK 1.5)

sqljdbc.jar

SQL Server (JDK 1.6)

sqljdbc4.jar

SQL Server (JDK 1.7)

sqljdbc41.jar

SQL Server (JDK 1.8)

sqljdbc42.jar

SQL Server 2019 (JDK 1.8)

mssql-jdbc-7.4.1.jre8.jar

IBM DB2 UDB Type-2 (JDK 1.4/JDK 1.5)

db2java.zip

IBM DB2 UDB Type-4 (JDK 1.4/JDK 1.5)

db2jcc.jar

db2jcc_license_cu.jar

IBM DB2 UDB (JDK 1.6)

db2jcc4.jar

IBM DB2 for IBMi (IBM i)

jt400.jar

For the Oracle database, you can locate the driver file in these locations:

  • Beginning with WebLogic 12.1.3, WebLogic is pre-configured to use a bundled Oracle 12c database JDBC driver. This JDBC driver comes pre-installed with the WebLogic Server installation, and no additional steps are required to connect to an Oracle 12c database.

  • Oracle Database

    Your installation of an Oracle database product includes the JDBC Thin driver for use with JDK 1.2 and JDK 1.3.

  • Oracle Technology Network (OTN)

    https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

  • JD Edwards Update Center

    Search for classes12.jar at this link:

    https://updatecenter.oracle.com/