JDBC - External Queries - 3

JDBC_ExternalQueries_3

<?xml version="1.0" encoding="UTF-8"?>
<mule xmlns="http://www.mulesoft.org/schema/mule/core" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:jdbc="http://www.mulesoft.org/schema/mule/ee/jdbc"
xmlns:http="http://www.mulesoft.org/schema/mule/http"
xmlns:beans="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/3.1/mule.xsd
http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/3.1/mule-http.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.mulesoft.org/schema/mule/ee/jdbc http://www.mulesoft.org/schema/mule/ee/jdbc/3.1/mule-jdbc-ee.xsd">

	<context:property-placeholder location="jdbc.properties"/>

	<!-- Include the file containing the statements -->
	<beans:beans >
		<beans:import resource="mule-config-extras.xml"/>
	</beans:beans>

        <jdbc:connector  dataSource-ref="jdbcDataSource" name="jdbcConnector" >
     	        <jdbc:query key="selectQuery" value-ref="formatedQuery" />
	</jdbc:connector>
	
	<flow name="testFlow">
		<http:inbound-endpoint host="localhost" path="test" port="9999"   />
		<jdbc:outbound-endpoint queryKey="selectQuery"  exchange-pattern="request-response"/>
	</flow>
</mule>