Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <mule xmlns:jdbc-ee="http://www.mulesoft.org/schema/mule/ee/jdbc" xmlns:jms="http://www.mulesoft.org/schema/mule/jms" xmlns="http://www.mulesoft.org/schema/mule/core" xmlns:doc="http://www.mulesoft.org/schema/mule/documentation" xmlns:spring="http://www.springframework.org/schema/beans" version="EE-3.3.2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
- http://www.mulesoft.org/schema/mule/ee/jdbc http://www.mulesoft.org/schema/mule/ee/jdbc/current/mule-jdbc-ee.xsd
- http://www.mulesoft.org/schema/mule/jms http://www.mulesoft.org/schema/mule/jms/current/mule-jms.xsd
- http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
- http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd ">
- <jms:activemq-connector name="Active_MQ" specification="1.1" brokerURL="tcp://localhost:61616" validateConnections="true" doc:name="Active MQ"/>
- <jdbc-ee:oracle-data-source name="oracle" user="CDF" password="CDF" url="jdbc:oracle:thin:@//localhost:1521/xe" transactionIsolation="UNSPECIFIED" doc:name="Oracle Data Source"/>
- <jdbc-ee:connector name="oracle_connector" dataSource-ref="oracle" validateConnections="true" queryTimeout="-1" pollingFrequency="0" doc:name="Database"/>
- <flow name="CDF_getterFlow1" doc:name="CDF_getterFlow1">
- <jms:inbound-endpoint queue="cdfquery.in" connector-ref="Active_MQ" doc:name="JMS"/>
- <set-variable variableName="query" value="SELECT * FROM your_table" doc:name="Variable"/>
- <outbound-endpoint address="jdbc://#[flowVars['query']]" exchange-pattern="request-response" doc:name="Generic"/>
- <logger message="JDBC QUERY RESULT: #[payload]" level="INFO" doc:name="Logger"/>
- </flow>
- </mule>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement