Update the Database Drivers in the JDBJ.ini File (Tools Releases Prior to 9.2.9)

The Web Client installer updates the JDBJ.ini file with settings for the databases to which the Web 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\WebDevFeature\<WLSH4A_or_WASH4A>\JDBC

Note: If you copy additional database drivers into the <Client Install Path>\misc directory after installing WLSH4A or WASH4A, 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:

    For WLSH4A:

    • <Client Install Path>\system\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\classes
    • <Client Install Path>\<pathcode>\ini\sbf

    For WASH4A:

    • <Client Install Path>\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\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