Tuesday, February 15, 2022

OIC - Rest HTTP Verb Put vs Patch

Following HTTP verbs are available:

GET: Retrieves information. If you select this option, you can not configure a request payload for this endpoint.

PUT: Updates information.

POST: Creates information.

DELETE: Deletes information. If you select this option, you can not configure a request payload for this endpoint.

PATCH: Partially updates existing resources. The patch verb does not work with a non-SSL rest service.

PUT vs PATCH:

The HTTP PATCH method offers a way to apply partial updates to resources. As a result, clients need to send only the differences in their request.

Where as, HTTP PUT method replaces or updates a resource entirely.

For example, /Users >>

{"User":"abc","Email":"abc@domain.com"}

PUT: It includes all parameters 

PUT /Users/1

{

"User":"cde",

"Email": "cde@gmail.com"

}

PATCH: It includes the one to be updated.

PATCH /Users/1

{

"Email":"cde@gmail.com"

}




Monday, February 14, 2022

XSD - Opaque schema

Opaque schema:

<?xml version = '1.0' encoding = 'UTF-8'?>  

<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"

            xmlns="http://www.w3.org/2001/XMLSchema" >

      <element name="opaqueElement" type="base64Binary" />

    </schema>

OIC - Read Json data received as json string

Steps:

  • Write Received Json string to stage directory as binary content using stage action oraext:encodeBase64() function and an opaque schema.
  • Read data written in the stage directory using stage read action and sample json file as reference.
  • Map the read json to response of the integration.
Rest configure input and output:

Input xsd:
<?xml version="1.0" encoding="windows-1252"?>
<Input xmlns="www.oracle.com"/testing">
<JsonDataInString></JsonDataInString>
</Input>

Output json:
{
"Id":"",
"Name":""
}
Opaque xsd to write in stage binary:

<?xml version = '1.0' encoding = 'UTF-8'?>  
<schema targetNamespace="http://xmlns.oracle.com/pcbpel/adapter/opaque/"
            xmlns="http://www.w3.org/2001/XMLSchema" >
<element name="opaqueElement" type="base64Binary" />
</schema>

Steps with POC screenshots:
























Saturday, February 12, 2022

Curl command links

 Curl command - Test a rest API

Unix links

  1. Unix or AIX - SFTP or SSH - no matching host key type found. Their offer: ssh-dss
  2. LINUX - UNIX - AIX commands -3 Ways to Create a Text File Quickly Through the Linux Terminal
  3. Unix or AIX box - remove zero size files from a directory
  4. Unix/AIX box - Certificate expiration date check
  5. Unix/AIX box : count word occurrences in text file
  6. Shell script to move files older than 10 days
  7. cron-job-and-shell-script-remove old files from unix directory
  8. Move files from AWS S3 bucket location to another location using EC2 command
  9. Count number of files in aws s3 bucket location using EC2 command

Database links

Database related topics:

  1.  database-schedule-using-dbms-job
  2. Database - create package and procedure
  3. How to export data dictionary with Oracle SQL Developer
  4. Database - Create a sequence
  5. SQL - How to Optimize SQL Queries
  6. 12c SOA Weblogic console - Database - shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: No such file or directory error
  7. DB Offset - Fetch clause
  8. DB - Check the status for all type of objects using user_objects
  9. DB - Count(*) vs count(1) vs count(column_name
  10. DB - LISTAGG() function | Aggregate fuction
  11. odi datafile check used and allowed max size
  12. SQL WITH Clause uses
  13. odi sql query to monitor temp size and resize
  14. What is the use of decode function in SQL?
  15. Db - insufficient privileges issue while using dbms_scheduler create job




Weblogic or admin tasks

12c-soa-weblogic-certificate-import steps


















Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...