My Oracle Support Banner

E1: ORCH: Database Connector Sample With Oracle DB and TR 9.2.5.4 and Above - Groovy And Jython (Doc ID 2861572.1)

Last updated on FEBRUARY 02, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Goal

Starting with Tools Release 9.2.5.4, the template for creating new Database Connections has changed.  Instead of implementing Groovy SQL, it uses Java SQL where the method has changed from

HashMap < String, Object > main(OrchestrationAttributes orchAttr, Sql sql, HashMap inputMap)

To

HashMap<String, Object> main(OrchestrationAttributes orchAttr, Connection sqlConnection, HashMap inputMap)

This document provides a simple example using Select from Address Book table F0101 for the Address Book number input. Thsi document also provides and example of Jython

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Groovy Example
  Jython Example

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.