Obtain JDBC Drivers
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.htmlJD Edwards Update Center
Search for
classes12.jarat this link: