Update the Database Drivers in the JDBJ.ini File (Tools Release 9.2.9)

The Development Client installer updates the JDBJ.ini file with settings for the databases to which the Development Client will connect based on the JDBC database drivers found in this directory:

<Client Install Path>\misc

These JDBC database drivers are copied from this directory:

\\<deployment server name>\<release>\OneWorld Client Install\ThirdParty\JDBC

Note: If you copy additional database drivers into the <Client Install Path>\misc directory after installing the Development Client, you must update the list of drivers in the JDBJ.ini file. This update must occur on each Development Client because the jdbj.ini template is built into the Development Client installer.

To update the database drivers in the JDBJ.ini file:

  1. Edit the JDBJ.ini files, which are typically found in these directories on your JD Edwards Development Client machine:
    • <Client Install Path>\system\classes
    • <Client Install Path>\<pathcode>\ini\sbf
  2. Locate the section: [JDBj-JDBC DRIVERS] and comment (add a hash or pound sign '#' at the beginning of the line) to disable any drivers that are not needed and uncomment (remove any hash or pound signs '#' at the beginning of the line) to enable any drivers that are needed.

    The following table lists the database driver names for the types of databases that EnterpriseOne supports:

Database Setting in [JDBj-JDBC DRIVERS]

Oracle

ORACLE=oracle.jdbc.driver.OracleDriver

IBM DB for i

AS400=com.ibm.as400.access.AS400JDBCDriver

SQL Server

SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver

IBM DB2 for Linux, UNIX, and Windows UDB=com.ibm.db2.jcc.DB2Driver