Deploying ADF BC SDO Service in oracle java cloud

In this post i will try to explain the process of deploying the ADF BC SDO service in oracle java cloud (PAAS). There are couple of pre-requisties to follow this post, they are
1) Oracle java cloud account to deploy the web service.
2) HRModelSDOService application.

I had used the Jdeveloper version 11.1.1.7 in all screen shots except in step 13 and 14 (where i had used 11.1.2.4). All other steps almost similar in both the verions.
Let us see the steps required to achieve this,

• Unzip the HRModleSDOService.zip to HRModelSDOService folder.
•  Open the application in jdeveloper. 

• If you get a warning for migration of project, Click Yes on “Do you want to migrate these files”.
• Expand the HRModelSDOService and right click and select configurations on HRSdoAppModule.

• We have to change the JDBCDataSource value of all the three app modules. Select each module and click on Edit. 

• Change the Datasource name to “database” (as this the JNDI name of cloud database).

• Repeat the above step for the remaining two app module configurations (HRSdoAppModuleShared, HRSdoService).
• Click ok on Manage Configurations window.

• Right click on the HRModelSDOService and click on project properties.

• Select  the Deployments tab and delete the existing profile and create a new profile with   Archive Type = Business Components Service Interface. Name  = HRModelSDOService

• Click on the application menu of the HRModelSDOService application and select Application Properties.

• Go to Deployments and delete the existing deployments and create a new deployment profile with Archive Type = EAR File, Name = HRModelSDOService

• Go to Application assembly of the new created deployment profile and select Middle Tier and EJB.

• Select weblogic under Deployment, Click on ok and select only “Application Policies” check box on the deployment window (unselect all the others). Click ok.

• Open Application Resourcesà Descriptors à META-INFà weblogic-application.xml

• This file should have the following content, if it has any duplicate entiries delete them.

• Save All. Now we are ready to generate the ear and deploy. Select the Application menu à Deploy à HRModelSDOService

• Select Deploy to EAR option and click on Finish.

• Get the ear path from the deployment log.

• Log into java cloud service and click on Deploy New. Select the Ear file and click on Deploy.
• Verify the Deployment job status in the status message; once it is completed we can access the deployed web service. Get the URL of the deployed application from Test application link.

• Access the web service with appending the relative URI(/HRSdoService) of the service to the above URL . Web Service URL will be like  https://XXXXXX.com/HRSDOService/HRSdoService

REST service in OSB - Creating a WSDL Proxy for REST Service

In this post we will see how to consume a RESTful service in OSB and create a WSDL proxy for the same so that that the WSDL clients can consume.

Steps:
1. Consuming the REST Serivce in OSB and creating a business service.
2. Creating a WSDL proxy and connecting routing it to the REST business Service.


Consuming REST service in OSB:

1. Create a Oracle Service Bus configuration Project in OEPE- eclipse.

2. Create a Oracle Service Bus Project

3. Create folders business services, proxy services, jars, wsdls under project.

4. Create a Business service under business services folder.

5. Select Messaging service in the General tab and select the request and response message types in as per your requirement.

6. Add the Rest service url in the Transport tab.

7. Leave the remaining tabs with defaule values.
8. You can test the busieness service(if you want) by exporting the project from eclipse and importing in OSB console.

Creating WSDL Proxy for REST service:

1. Create a WSDL which will be used to create the proxy for the REST business service.
2. The WSDL should contain the input, output and operation that it exposes. Please find the below WSDL for reference (it show only the operation and bindings).

3. Create a new proxy service and select Service Type as WSDL web service and browse and select the WSDL that is created in the previous step.

4. Leave all other tabs/fields as default values and click on messag flow tab.

5. Create a conditional branch under the proxy service and set the condition for branch as the method argument from the input variable. (in the example that is depicted here the http method name is passed in the input)

6. Add a branch and for handling GET requests.

7. Add a Route node under GET brancha and pipeline pair which will route to the REST business service which is created earlier.

8. Now we have to prepare the request pipeline to invoke the REST service. The REST url for the GET method will be http://hostname:port/context/event/1 where /1 is the relative uri which will fetch the event details with event id 1.

9. So we need to set http-method (value GET), and relative-URI value (the id value that is passed to the WSDL proxy service.

10. Add an insert action which will set the http-method.

11. Add an assign action which will get the id from the wsdl input and set it to a variable (id).

12. Set the relative URI.

If your REST service is expecting the query string( like http://hostname:port/context/event?id=1) instead of relative URI then set the query string as mentioned below, 

fn-bea:inlinedXML(concat('', concat('', 'id=',$id, ''), '

'))
13. Now the request part is completed. 

14. If your REST service returns the xml you can directly map it to the reponse of the proxy service(after performing required transformations).

15. In this example my REST service returns JSON response so i need to convert it into the xml format which we will see in the below steps.

16. In the response pipeline add an Assign activity which will assign the response body to a variable 'jsonRes'.

17. Now we need to convert the json reponse to xml format. For this we need the JSONXMLConverter.jar which has two methods to conver json to xml and vice versa. For this jar to work we need to copy following jar under the lib folder of your OSB domian.

• commons-beanutils-1.8.3.jar
• commons-beanutils-bean-collections-1.8.3.jar
• commons-beanutils-core-1.8.3.jar
• commons-lang3-3.1.jar
• ezmorph-1.0.6.jar
• json-lib-2.4-jdk15.jar
• junit-4.10.jar
• xom-1.2.8.jar

18. Add a java callout activity which will call the json2xml() in JSONXMLConverter.jar and pass the input as jsonRes and assign the output to 'xmlRes' variable.

19. Replace the response body node contents witht xmlRes.

20. Now we can test the proxy service from OSB console or from SOAP UI (we can get the exposed wsdl of proxy from OSB console).

21. We can configure the other http methods in the same manner.