Oracle Service Bus 12C REST Example from Scratch – PART 2

In the previous part we understood how to set up OSB environment. In this Demo I will explain how to create a REST OSB Proxy Service and Business Service.

Now as the JDEVELOPER Studio Edition Version 12.2.1.4.0 and OSB Version 12.2.1.4.0 has been setup, I will first create a Business Service. For this DEMO I am not using any WADL, instead I will try to consume a REST API already available – http://dummy.restapiexample.com/create

 Step1: Click FileàNew ApplicationàService Bus TieràService Bus Application with Service Bus Project (I have provide the name of Application as Practice and Project as RestDemo)

Step2: Open the composite. Drag the REST Adapter to the External Services. Give name as DummyRESTBS. Follow the screenshots below

Step3: Generate a pipeline to connect to BusinessService. From the image above you can find a WADL was already generated by OSB while creating the Business Service. Follow the steps below and ensure that the pipeline is exposed as a Proxy Service

Step4: Connect Pipeline with the BusinessService

Step5: Right Click on the ProxyService and click RUN. This will open the Test Console for the proxy in the OSB integrated server. From the API the following use the below payload for testing

{"name":"test","salary":"123","age":"23"}

Jdeveloper Studio Edition Version 12.2.1.4.0 - REST ADAPTER ERROR FIX

If you get rror while using REST adapter– SOA 12.2.1.4 JDeveloper Error: NoClassDefFoundError com/fasterxml/jackson/core/JsonFactory

The following steps needs to be performed –

Download Bundle Patch Patch 30482761: SOA 12.2.1.4 JDeveloper Error: NoClassDefFoundError com/fasterxml/jackson/core/JsonFactory from Oracle Support and Unzip to your local

1.                   Open cmd in admin mode and follow the instructions as below

a.                   cd C:\Oracle\Middleware\Oracle_Home\OPatch

b.                   C:\Oracle\Middleware\Oracle_Home\OPatch>

SET ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home

c.                   C:\Oracle\Middleware\Oracle_Home\OPatch>

SET PATH=%PATH%;C:\Oracle\Middleware\Oracle_Home\OPatch

d.                   C:\Oracle\Middleware\Oracle_Home\OPatch>cd C:\Users\dhiresh.kavi\Downloads\30482761

e.                   C:\Users\dhiresh.kavi\Downloads\30482761>opatch apply

[Oracle Interim Patch Installer version 13.9.4.2.1

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : C:\Oracle\Middleware\Oracle_Home

Central Inventory : C:\Program Files\Oracle\Inventory

   from           :

OPatch version    : 13.9.4.2.1

OUI version       : 13.9.4.0.0

Log file location : C:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch2020-03-29_00-50-26AM_1.log

OPatch detects the Middleware Home as "C:\Oracle\Middleware\Oracle_Home"

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   30482761

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = 'C:\Oracle\Middleware\Oracle_Home')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '30482761' to OH 'C:\Oracle\Middleware\Oracle_Home'

Patching component oracle.soacommon.plugins, 12.2.1.4.0...

Patch 30482761 successfully applied.

Log file location: C:\Oracle\Middleware\Oracle_Home\cfgtoollogs\opatch\opatch2020-03-29_00-50-26AM_1.log

OPatch succeeded.]

     3.  cd C:\Oracle\Middleware\Oracle_Home\jdeveloper\jdev\bin --> run -jdev clean 

Oracle Service Bus 12C REST Example from Scratch – PART 1

SETTING UP LOCAL OSB 12C ENVIRONMENT VIA JDEVELOPER INSTALLATION

Step 1: Download SOA Suite from here
Step 2: Download Java SE Development Kit 8u241 from here
Step 3: Install Java
Step 4: Run cmd as Administrator à cd to Jdk bin location à C:\Program Files\Java\jdk1.8.0_241\bin>java -jar C:\swdownloads\fmw_12.2.1.4.0_soa_quickstart.jar
Follow instructions and keep clicking Next. Jdeveloper will be installed with SOA SUITE 12C and OSB 12C

Step 5: Follow the sub steps below to Start Integrated Server

1. Open JDeveloper Console click RUNàClick Start Server Instance
2. Provide username and password. Keep weblogic and welcome1. Don’t change any port and Click Next
3. You will start seeing the below messages -  
   #################################################[Waiting for the domain to finish building...]
   [12:35:36 PM] Creating IntegratedWebLogicServer Domain...
   [12:38:11 PM] Extending IntegratedWebLogicServer Domain...
   [12:39:51 PM] Extending IntegratedWebLogicServer Domain...
   [12:41:06 PM] Extending IntegratedWebLogicServer Domain...
   [12:42:55 PM] IntegratedWebLogicServer Domain processing completed successfully.
   *** Using HTTP port 7101 ***
   *** SSL port conflict detected.  The SSL port will be reassigned to port 7104. ***
   C:\Users\dhiresh.kavi\AppData\Roaming\JDeveloper\system12.2.1.4.42.190911.2248\DefaultDomain\bin\startWebLogic.cmd
   [Starting IntegratedWebLogicServer.]
   [waiting for the server to complete its initialization...] Depending on the system specifications, you will something like this
   [IntegratedWebLogicServer startup time: 420989 ms.
   [IntegratedWebLogicServer started.]
   **** Due to port conflicts, the server is configured at Listen port 7101, SSL port 7104.]#############
4. You can open the EM Console using this URL: http://127.0.0.1:7101/em/
   Weblogic Console using this URL: http://127.0.0.1:7101/console/
   Service Bus Console using this URL: http://127.0.0.1:7101/servicebus/

Create REST Integration using Oracle Integration Cloud

Using OIC this post explains easiest way to create a REST API using OIC integration

Step 1: Create an outbound Rest Connection using adapter as REST and type as INVOKE. Keep Connection Type-REST API Base URL

Provide- REST URL and Security Policy as needed to create Outbound

Step 2: Create Generic Inbound Rest Connection using adapter as REST and type as TRIGGER. The creds needed to invoke will be basic and will be same as the creds needed to login to OIC.

Step 3: Create a Basic Routing integration (Basic App to App with Data Routing). Drag the REST connection created in Step 2 

Provide a Name and DataType in Specify Query Parameters.

Configure the Response Payload

Click enter sample JSON which corresponds to the Invoke Connection created in Step 1

{

  "id": "Value"

}

Step 4: Drag the REST connection created in Step 1 into Drag and Drop an Invoke and perform the same steps as done in Step 3

Step 5: Do the mapping for Execute and Execute Response. Do validations and the mappings should now look green. 

Step 6: Add tracking. 

Step 7: Activate the integration

Step 8: Get the URL details and set up the SOAP UI with the URL. Give the UserId and Password used to login the OIC. Provide the Domain from the URL.

Step 9: Add the string, since it’s a GET and provide value. Run the request and the response received will be response. 

REST or Representational State Transfer

REST - Is it a Architecture design pattern or Communication protocol

REST is an Architecture design pattern that follow a set of rules to create Web Services, mostly in the context of HTTP protocol communication. 

REST METHOD	USE
GET	READ
POST	CREATE
PUT	UPDATE
DELETE	DELETE
HEAD	RESPONSE STATUS (METHOD LEVEL)
OPTIONS	REQUEST INFORMATION (METHOD LEVEL)
TRACE	ECHO ORIGINAL REQUEST GOING TO CLIENT
PATCH	PARTIAL UPDATE
PROPFIND	RETRIEVES PROPERTIES DEFINED FOR RESOURCE
LOCK	LOCK RESOURCE
UNLOCK	UNLOCK RESOURCE

REST Data Types - 

STRING 

NUMBER

BOOLEAN

NULL

OBJECT

ARRAY