Creating RA JD Edwards Agent JDBC and Program Connection Objects

To link the RA JD Edwards Agent to JD Edwards, you must create the following in client 0:

  • A JDBC Connection object to connect the Agent to JD Edwards.
  • A default JD Edwards program Connection objects used to run Jobs.

You can override the JD Edwards program Connection object in JD Edwards Job definitions, but to do so, you must define one or more additional Connection objects in the client where you define Jobs.

The Login field on the Attributes page is not used for Automation Engine Jobs of the JD Edwards Agent.

Creating an RA JD Edwards Agent JDBC Connection Object

Create a JDEDWARDSAGENT > JDBCCONNECTION object in Client 0 as described in your Automation Engine documentation.

Define the Connection object by doing one of the following:

To: Do this:

Enter the host, port, and connect string in the provided fields for an Oracle database

Select Oracle in the Database Type field.

Fill in the Host, Port, and Service Name fields and keep the Free Form Entry box unchecked. The values you fill in will populate the read-only JDBC Connect String field in the Oracle 12c format: jdbc:oracle:thin:@//{host}:{port}/{service}, which is backwards compatible.

If you need to find your service name, you can do it in one of the following ways: 

  • Log into to SQL*Plus as the SYS user and enter the following command:

    • SQL> show parameter service_names

  • On the command line, enter the lsnrctl status command to get the services and instances available on the machine.

In previous releases, there was a SID field in place of the Service Name field. In those releases, the JDBC Connect String field was populated in the Oracle 9i/10g/11g format: jdbc:oracle:thin:@{host}:{port}:{sid}. If you need to continue using the older format going forward, you can enter the JDBC connect string manually as described below.

Enter the host, port, and SID in the provided fields for a SQL Server database

Select SQLServer in the Database Type field.

Fill in the Host, Port, and SID fields and keep the Free Form Entry box unchecked. The values you fill in will populate the read-only JDBC Connect String field in the SQL Server format: jdbc:jtds:sqlserver://{host}:{port}/{sid}.

There is no additional configuration for the driver with SQL Server since the RA JD Edwards Agent uses the built-in jdts.jdbc driver.

Manually enter a connect string

Select Oracle or SQLServer in the Database Type field.

Specify the database driver class, userid, and password.

Check the Free Form Entry box and enter a connect string in the JDBC Connect String field.
Manually enter an Oracle RAC connect string

Select Oracle RAC in the Database Type field.

Specify the database driver class, userid, and password.

Enter a RAC connect string in the Oracle RAC Connect String field.

Configuration Requirements for Connecting to an Oracle 12c Application Database

Configuring the RA JD Edwards Agent to connect to an Oracle 12c Application Database requires the ojdbc6.jar JDBC driver file. To put the ojdbc6.jar file in place:

  1. Stop the Agent.
  2. Copy the JDBC driver ojdbc6.jar file from the Oracle database client installation to the lib directory.

    3. The file is located at ORACLE_HOME/jdbc/lib/.

    For On Directory
    Automation Engine v11 or above UNIX bin/lib
    Windows bin\lib
    Automation Engine v9 or 10 UNIX bin/shared
    Windows bin\shared

    If you want to save the old file, you can copy it to a backup location outside the path of the Agent.

  3. Remove the old ojdbc14.jar file from the Agent directory, if there is one there.
  4. Unpack the ojdbc6.zip file, and copy the new ojdbc6.jar file to the Agent directory as follows:
    5. On Directory
    UNIX bin/lib
    Windows bin\lib
  5. Restart the Agent.

Configuration Requirements for Automation Engine v11.2 When You Do Not Use an Oracle 12c Application Database

Configuring the RA JD Edwards Agent to connect to an Application Database that is not Oracle 12c when you are using Automation Engine v11.2 requires the ojdbc<version>.jar file. To put the ojdbc<version>.jar file in place:

  1. Stop the Agent.
  2. Copy the JDBC driver ojdbc<version>.jar file from the Oracle database client installation to the lib directory.

    3. The file is located at ORACLE_HOME/jdbc/lib/.

  3. Unpack the ojdbc<version>.zip file, and copy the new ojdbc<version>.jar file to the Agent directory as follows.
    4. On Directory
    UNIX bin/lib
    Windows bin\lib
  4. Restart the Agent.

Creating RA JD Edwards Agent Program Connection Objects

Create a JDEDWARDSAGENT > JDEDWARDSCONNECTION object in Client 0 as described in your Automation Engine documentation. Optionally create additional Connection objects that can be used for Job overrides in the clients where you define Jobs.

The Login field on the Attributes page is not used for Automation Engine Jobs of the JD Edwards Agent.