Configuring the Schema Generation Utility

The Schema Generation Utility is delivered in a zip file in the system\classes folder. You must download the zip file to your local machine and set up certain files. You use these settings in Step 4.

Section

Setting

Value

[EVENTS]

initialContextFactory

For WebLogic Server, the default value is: weblogic.jndi.WLInitialContextFactory

For WebSphere Application Server, the default value is: com.ibm.websphere.naming.WsnInitialContextFactory

[EVENTS]

jndiProviderURL

For the Transaction Server running on a WebLogic Server, the value is: jndiProviderURL=t3://machine_name:machine_port

For the Transaction Server running on a WebSphere Application Server, the value is: jndiProviderURL=corbaloc::Machine_name:Port/NameServiceServerRoo

Note: Machine_name in this setting is the name of the machine where the Transaction Server is installed

Port in this setting is the Bootstrap Address port of the Transaction Server. Generally the port is 9810.

[EVENTS]

eventServiceURL

The value is: http://machine_name:port/e1events/EventClientService

Note: Machine_name in this setting is the name of the machine where the Transaction Server is installed, up, and running.

Verify the hostport property in the jas.ini file of the Transaction Server for port information and to find the exact port for the URL.

[SECURITY]

SecurityServer

Provide the name of the user's EnterpriseOne Security Server.

[JDENET]

serviceNameConnect

Provide the port that you are connecting on to the user's EnterpriseOne Security Server.

[INTEROP]

enterpriseServer

Provide the name of the user's EnterpriseOne Server.

[INTEROP]

port

EnterpriseOne Server port.

To configure the Schema Generation Utility:

  1. Navigate to the system\classes folder and unzip the SchemaGenUtil.zip file to the C:\SchemaGenUtil directory in your machine.

    Ensure to unzip the file with the full path information for each file in the zip file.

  2. Configure the files in your C:\SchemaGenUtil\config directory.

    Ensure that the configured files have the .templ file extension removed from them. The proper filenames for that directory are jdbj.ini, jdeinterop.ini, and jdelog.properties.

  3. Configure jdbj.ini and jdelog.properties files according to the environment.

    The simplest solution for the jdbj.ini file is to use the same file that has been configured on the Transaction Server.

    Note: See your JD Edwards EnterpriseOne systems administrator if you do not know the appropriate values for these files.
  4. Configure the jdeinterop.ini file sections and settings that are identified in the preceding table.

  5. Edit the C:\SchemaGenUtil\runSchemaGenUtilityDriver.bat file, pointing it to the location of the installed JRE.