Oracle Service Bus: Flat file to JMS routing with Xquery transformation

1. Login into Weblogic console http://localhost:7021:console. JMS Modules -> JMS resources and create a new JMS queue “File2JMS_BSRequest” Select the subdeployment as “wlsbJMSServer”

2. Create new Oracle Service Bus configuration project and then new OSB project.


3. Drag and drop the two schema files into the OSB project (File2jms) in WebLogic workshop IDE.

With the source and target schema impoerted, create a new xquery file in Oracle Service Bus and map the source and target field.

File2JMS -> New “XQuery Transformation”


Select the source and target, xml to xml mapping in the XQuery Transformation.


4. Create a new business service.

Select service as messaging service, message type as xml [do not use browse button leave it empty], and select transport as jms.

In the transport confifuration, select jms as the protocol. Map the endpoint URI to jms queue.


In the JMS transport page, select Queue as the destination type and set the message type to ‘text’.

5. Create a new proxy service called ‘FileRoute.proxy’.


Select service as messaging service, message type as xml [do not use browse button leave it empty], and select transport as file.

Create 2 folders in your C drive, ‘newdir’ and ‘stagedir’.


Set the polling interval to 5 seconds and set the staging directory.


Go to the message flow tab, from the design palette drag and drop Route activity into the process flow diagram after FileRoute activity.

Drag and drop routing activity after the route node. (Select from Route Action – Communication->Routing)

We need to add 2 assign and 1 insert activity.
Drag and drop Assign activity from the design palette into the Request Action pipeline.

Browse the Xquery template, drag and drop the SourceCustomer from the variable structure.


Enter ‘xml’ in the vairable field.

In the second assign activity, enter ‘
’ , in the expression field and set variable field to ‘body’.

In the insert activity, copy the content of the xml variable to the body variable



Click on the Routing activity in the process diagram and select the business service.

6. Deploy the OSB_Config project to the Weblogic Server and goto the OSB Console to execute the process.

7. Goto the Weblogic JMS monitoring console to the see output with concatenated message.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s