Getting started with Oracle SOA Cloud Service: Deploying First DB Adapter Service on Cloud

In this post we will deploy the simple database adapter service. This service acts like a get Customer service, which pulls the data from Database.

Since we already configured the Oracle Database Service,

1, I created a CUSTOMER TABLE in Oracle DB cloud.

2. I created a Datasource in weblogic console point to the DB cloud service.

3. I created the JCA connection in DBAdapter Lib under deployment and upgraded the lib.

4. I Created a simple BPEL process to get the Cust ID and Fetch the Customer Data from Table.






5. Deploy the composite through EM console, same like a on-premise SOA server.

6. Once deployed, test the composite, and you will get the WSDL URL. This URL is over the public domain, so i just added the URL in SOAP UI and tested.

http://oc-****.compute.oraclecloud.com:8080/soa-infra/services/MyPartition/GetCustomer/fetchcustbpel_client?wsdl

Though it was a simple service I though it will take a bit longer to provide the response, but I see that the response is pretty quick, avg response time was around 180ms.

 Apart from some restriction or changes, using Oracle SOA Cloud Service is almost similar to using On-Premise SOA server, but it take away all the admin/maintenance activities.

Popular posts from this blog

API Design First approach: Implementing quick mock API's using swagger hub and postman

Image
Consider a scenario, where you as a API developer been ask to to implement the API's for a new mobile/web application team. The requirement is to implement a application to allow users to manage orders.         Mobile APP -> API infra->Backend enterprise system While implement a full working API might take days, you also do not want the application team to wait till the API's are ready. Thus, in most case we end up implementing the mock API's with sample scenarios. In this post, we will define an API using swagger openapi 3.0 yaml specification in swaggerhub. We will then use the definition to implement mock API's in postman. Even though postman provide option to define the API's, i liked swagger hub much better, it allow you to view your API on right side.  For this post I implemented API definition in swagger, please find the below link. https://app.swaggerhub.com/apis-docs/lopesrohan1988/ordermanagement/1.0.0 API Definition can be found at below link: h...
Read more

Combine or Merge XML documents in Single XML using Boomi & Groovy

Image
In this small post will try to show how you can merge multiple XML Documents in Boomi.  Consider following scenario where you have to merge Document 1 & 2 in a new Document 3 Document 1: <?xml version="1.0" encoding="UTF-8"?> <tns:OutputParameters xmlns:tns="http://sample.com">    <tns:Book>       <tns:Names>          <tns:Name>XZY World</tns:Name>       </tns:Names>       <tns:Authors>          <tns:AuthorID>12354</tns:AuthorID>       </tns:Authors>    </tns:Book> </tns:OutputParameters>   Document 2: <?xml version="1.0" encoding="UTF-8"?> <tns:OutputParameters xmlns:tns="http://sample.com">    <tns:Book>     ...
Read more

JAVA embedding in Oracle SOA 12c

Image
In this post we will explore how to EMBED Java or call Java API from Oracle SOA BPEL process. In order to demonstrated this, I have created a simple JAVA project with 3 classes. 1.        Account.java -> This class represent Account DTO       2.       Party.java -> This class represent a party (customer) DTO       3.       GetNumber.java -> This class contains the method that takes Party DTO as input and apply some business logic and return party’s AccountDTO in response. public Account getNumber(Party party) The above classes are created to simulate the calling of actual business logic API’s. Account.java Party.java GetNumber.java public class Account {     public Account() {         super();     }     String account;     public v...
Read more