Copying the JDBC Drivers (Tools Release 9.2.9)

On the Deployment Server, create a \JDBC subdirectory under the “ThirdParty” folder. For example:

<E1_dep_svr_install_directory>\OneWorld Client Install\ThirdParty\JDBC

Note: If you must copy the JDBC files to a different directory for some reason, you must add an entry to the oraparam.ini file for the Development Client installer to indicate the location of that JDBC directory. Edit the oraparam.ini file located in this directory:

<E1_dep_svr_install_directory>\OneWorld Client
                        Install\Install

. Add this entry to the [FileLocations] section of the oraparam.ini file: JdbcPath=<UNC_Path_to_JDBC_files>

For example:

[FileLocations]

JdbcPath=\\depsvr2\E920\My_JDBC

Note: If you leave this entry out, the Development Client installer will look for the JDBC directory under

OneWorld
                                Client Install\ThirdParty

.

Important: You must delete any obsolete driver files because all drivers in this directory will be loaded by EnterpriseOne. If obsolete drivers exist, they may be used instead of newer drivers. Check Oracle Certifications for the latest drivers.

Refer to Understanding Certifications for information on where to obtain the JDBC drivers.

The required JDBC drivers for each platform are listed in the following table, but check Oracle Certifications for the latest drivers:

Database	Required Drivers	Comments
Oracle	ojdbc8.jar, ons.jar, ucp.jar	The JDBC driver for Oracle will automatically be downloaded to your system when you install an Oracle database client or server. If you install a different driver, the system may not function properly.
UDB/DB2	db2jcc4.jar	The JDBC driver for DB2/UDB is delivered with DB2/UDB server or client installation.
DB2/400 for IBMi	jt400.jar	The DB2/400 driver for the IBMi platform is delivered with the DB2/400 database installation.
SQL Server	mssql- jdbc-11.2.0.jre8.jar	Microsoft provides a type 4 JDBC driver with full support at no additional charge. Download the JDBC driver directly from Microsoft's website. Use the installation documentation that comes with the download to install the JDBC driver into a temporary location.

Obtain the JDBC drivers and copy them to the JDBC directory you created in the first step.

When the Web Client is deployed to a target machine, these drivers are automatically installed into the following directory:

<Client Install Path>\misc