Oracle Workshop for WebLogic: Create Proxy Service and XQuery Transformation

Oracle Service Bus Proxy Service

OSB Proxy Service (Image from: docs.oracle.com)

Oracle Service Bus proxy services design for managing services, transforming messages, and routing messages through the enterprise services. Oracle Service Bus uses proxy services to route messages between business services (such as enterprise Web services and databases) and service clients (such as presentation applications or other business services).

A proxy service configuration includes its interface, transport configuration (protocol, endpoint), security configuration, and a message flow definition. The message flow definition defines the logic that determines how messages are handled as they flow through the proxy service.

Continue previous tutorial about create WSDL, now we will use WSDL which have been made to build a simple OSB proxy service.

Create Proxy Service

Right click from “Proxy Service” directory choose New → Proxy Service

New Proxy Service

Provide file name: SimpleCalculator for this proxy service.

Proxy Service Name

New Tab will be open, let’s focus on sheet “General”. In option Service Type, choose Create New Service WSDL Web Service. Browse for WSDL file SimpleCalculator, and expand via plus (+) tree. Choose SimpleCalculatorServiceSOAP (port).  General sheet will be like bellow picture.

Proxy Service General Configuration

Ignore next sheet and jump to last sheet, Message Flow. Right click One icon in the center of canvas choose Insert Into → Pipeline Pair.

Insert Pipeline Pair

Right click Response Pipeline choose Insert Into → Stage.

Insert Stage

Right click Stage choose Insert Into → Message Processing → Replace.

Insert Replace Node

Replace action need a XML transformation. We will build a XQuery transformation to transform input param into output param.

Create XQuery Transformation

XQuery transformation maps can describe XML-to-XML, XML to non-XML, and non-XML to XML mappings. First, create folder named “XQuery” under SimpleCalculator. After that, right click XQuery folder and choose New → XQuery Transformation.

Create Xquery Transformation

Now supply filename for this object. In this tutorial, the file named SimpleCalculatorAddResponse. The naming should be minimal consist of 3 elements: Project Name, Operation Name, and Request Type (Request / Response).

Xquery Name

Select source type for the transformation. Expand all node of SimpleCalculatorService.wsdl. Select Node Add and click Add Button placed in the middle. The element will be added to right column.

Xquery Source Type

Select target type for the transformation. Expand all node of SimpleCalculatorService.wsdl. Select Node AddResponse and click Add Button placed in the middle. The element will be added to right column. Then finish the wizard.

Xquery Target Type

A new tab will be opened. Drag node ANumber di the left and drop to node result in the right.

Xquery Transformation

Switch to sheet source, XML transformation will be shown like bellow:

<ns0:AddResponse>
	<result>{ data($add1/ANumber) }</result>
</ns0:AddResponse>

Modify the source by add BNumber, so the source will be like bellow.

<ns0:AddResponse>
	<result>{ data($add1/ANumber) + data($add1/BNumber) }</result>
</ns0:AddResponse>	

Save and switch back to Design sheet. The result will be like bellow:

Xquery Transformation Result

Back to Proxy Service Message Flow. Select node Replace, edit the properties with bellow setting:

• XPath   → . (dot character)
• In Variable   → body
• Radio Button   → Replace Node Contents

Replace Properties

• Expression   → Follow the link. A new window will be open. Go to tab XQuery Resources, expand body variable in the right,  drag node Add to blank column (binding). Finish the step by click OK.

Xquery Expression Editor

Build a simple Proxy Service already finished. Now export project from Oracle Workshop so the resource can be imported to Oracle Service Bus Console. Ensure all tab have been saved, then choose File → Export… Choose Oracle Service Bus – Configuration Jar.

Export Osb

Specify Export Destination Jar File by click browse and then go to target folder location and give file name for the jar. Finish the wizard and jar file will be exported to the location specified.

Export Configuration

Finally, SimpleCalculator Proxy Service ready to deploy. In the next tutorial, we will deploy proxy service on Oracle Service Bus and testing after deployment.

Incoming search terms:

• osb replace example
• oracle service bus tutorial
• xquery transformation in osb tutorial
• xquery transformation in osb
• Transformation Maps osb
• use xquery cache data in osb
• failed to get operation name from incoming request in weblogic
• osb failed to get operation name from incoming request
• steps for creating proxy service in osb
• osb transformation tutorial
• oracle service bus xquery transformation
• xquery security vulnerabilities
• xquery transformation in message flow in osb tutorial
• osb xquery examples tutorials
• oracle osb tutorial
• using comman xquery file in proxy service
• osb xquery transformation
• pof config xml osb coherence
• oracle xquery osb
• how to convert xml to non xml in osb
• oracle workshop for weblogic: create proxy
• oracle osb Failed to get operation name from incoming request
• osb proxy services _db wsdl
• weblogic data source initial capacity explain in details
• coherence put key custom pof object example osb xpath function
• statement cache type lru
• adjust-date-to-timezone in bpel
• xquery fn:months-from-duration() osb
• proxy to proxy flow in oracle service bus blogs
• failed to get operation name from incoming request
• xquery in osb
• proxy services routing to another proxy service in osb
• proxy twitter
• proxy service in osb complete example
• proxy services in osb
• proxy services database design
• proxy services
• pof config xml into osb coherence
• proxy service wsdl for a messaging service
• proxy service with two business services
• pipeline pair proxy service
• osb xquery service functions
• osb xquery replace node value
• osb proxy service file
• osb proxy service port
• osb proxy service security configuration
• osb replace action example
• osb replace action with xq
• osb replace expression
• osb response cache expression
• osb sample oracle workshop
• osb service with weblogic datasource
• osb service xquery mapping
• OSB transforming services
• osb xquery how to select node value
• osb simple proxy google
• osb xquery binding variables
• osb xquery call java
• osb xquery choose nodes by type
• osb xquery how to select node value
• osb proxy service definition
• replace entire node osb
• xquery with OSB
• wsdl coding for oracle logic service bus
• wsdl coding for oracle logic service bus
• wsdl based proxy transformation using xquery
• why we use proxy services
• why we do xquery transformation
• what is xquery transformation in osb
• what is proxy service and business service in osb
• what is exact meaning of xquery in osb
• what is a osb proxy service in definition in details
• xml transformation using osb proxy service stage action
• xquery example in osb
• xquery webblogic config xml
• xquery transformations tutorials
• xquery transformation with replace action example
• xquery transformation in message flow in osb tutorial
• xquery resource osb
• xquery mapper in osb console
• xquery in osb console
• xquery for osb transformation
• xquery flow examples
• weblogic transforms wsdl
• weblogic domain pictures
• tabs in osb proxy
• swift message to xml format using xquery transformation in osb
• source to destination format osb
• simple osb payload transformation
• security proxy to proxy osb
• security protocol transformation on wsdl
• sample xquery transformation in osb
• sample routing logic for osb
• routing and transformation osb
• tips to design a new wsdl in osb
• transform web services using osb
• weblogic createwsdl.java:315 error
• weblogic createwsdl java:315 error
• Weblogic 10 3 5 exploit
• using xquery in replace node proxy service
• using xquery in osb
• tutorial on Google XQuery
• transforming service name wsdl
• transformations in osb
• transformation in osb using xquery
• routing and transformation example in osb xquery
• how to find the current line number through xquery in osb
• how to add node in osb transformation
• how can we create a request with no soap envelope in osb xquery transformation
• how can develop xqueries using workshop
• gmt to cst time conversion using xquery in osb
• getting started with osb xquery
• generate proxy service bus
• failed to get operation name from the incoming request+osb proxy service
• failed to get operation name from the incoming request+osb
• failed to get operation name from the incoming request osb proxy service
• how to add the osb in weblogic profile
• how to add utility to weblogic for xquery transformation
• how to add xquery function in osb proxy
• how to find duration time for xquery transformations in osb
• how to do message flow in proxy service
• how to develop a simple osb program
• how to create variables in osb as wsdl based proxy service
• how to create simple osb service
• how to create request for proxy service in osb
• how to create proxy service in osb as an xml input
• how to change xquery resource properties/properties weblogic using script
• how to assign header node in osb
• failed to get operation name from the incoming request osb
• failed to get operation name from incoming request business service
• how can develop xqueries using workshop
• create proxy service example
• connectionpoolprofiler java:230
• ConnectionPoolProfiler java
• can we call two business service from one proxy service
• can we call proxy service in osb
• can we add 2 route nodes in a single proxy service in osb
• call business services using proxy
• adding xml xquery lookup file to proxy service
• add node in osb
• create xquery from wsdl
• creating a xquery project in weblogic workshop
• creating and mapping web services in osb
• example on message transformation in osb
• example insert xquery in osb
• enrichment of xml using xquery in osb
• deploying proxy services like stage cache
• datetime format example in osb xquery
• date time format and comparison in osb
• date funtions in oracle osb
• creating proxy service using osb console
• creating proxies for web services in osb
• xquery flow examples
• osb proxy service cache permormance tuning tips
• osb configuration jar in weblogic console
• osb configurar proxy
• osb adding elements
• oracle service bus xquery tutorial
• oracle service bus xquery substring
• oracle service bus xquery lookup business service
• oracle service bus xquery alerts
• oracle service bus tutorials
• oracle service bus proxy service tutorial
• osb configure wsdl location proxy
• osb create proxy service for website
• OSB EJB Failed to get operation name from incoming request
• osb proxy service body nodes
• osb properties file
• OSB oracle
• osb message non xml to xml
• osb message flow tutorial
• osb google services
• osb get service name xquery
• osb file transformation file to business services
• osb examples tutorials
• oracle service bus properties file contents to message flow
• oracle service bus icon
• oracle osb xquery transformation
• how to write xquery transformation in osb
• how to use xquery in osb
• how to test a xquery transformation in osb
• how to perform multiplication in xquery in osb business service project
• how to map current datetime in xquery in osb
• how to make xquery transformation in osb
• how to get wsdl description for a deployed proxy service in osb
• how to get values from xquery in a proxy service in osb
• how to get the wsdl of a proxy service in osb after deploy
• how we difined message flow in osb proxy service
• mapping between source and destination objects using xquery in osb
• mapping xquery elements using oracle workshop
• oracle osb all node
• oracle esb xquery substring example
• oracle esb + xquery + substring+ example
• oracle coherence cache with osb custom xpath functions with example
• oracle coherence cache with osb custom x path functions
• oracle bpel xquey substring
• oracle bpel transformation format-datetime + substring
• need to create osb project without using wsdl
• message transformation in osb
• how to get request data from proxy service in osb