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
<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:
- 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
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 |