My Oracle Support Banner

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

Last updated on APRIL 08, 2022

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.

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

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