Download to read offline
![Flow Source <flow name="mssqltestFlow1" doc:name="mssqltestFlow1"> <http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" doc:name="HTTP"/> <db:stored-procedure config-ref="Generic_Database_Configuration" doc:name="Database"> <db:parameterized-query><![CDATA[{call test.fetchResults(:id)}]]></db:parameterized-query> <db:in-param name="id" type="INTEGER" value="#[payload]"/> </db:stored-procedure> <logger message="#[payload.resultSet1]" level="INFO" doc:name="Logger"/> <json:object-to-json-transformer doc:name="Object to JSON"/> </flow>](https://image.slidesharecdn.com/runningmssqlstoredproceduresinmule-150917100321-lva1-app6892/75/Running-ms-sql-stored-procedures-in-mule-10-2048.jpg)
Uploaded byAnilKumar Etagowni
Running ms sql stored procedures in mule
This document provides instructions for connecting to a Microsoft SQL Server database from Mule and executing a stored procedure to retrieve result sets in JSON format. It describes the prerequisites, Mule flow configuration including global configuration, data source configuration, database component configuration, and logger component configuration to call a stored procedure and output the results as JSON.
Running ms sql stored procedures in mule
- 1. Running MsSQL StoredProcedures in Mule
- 2. In this tutorialwe are connecting to MsSQL Stored Procedure to fetch the Result Set in JSON Format. Pre-requisites: ● Anypoint Studio ● MsSQL database and Stored Procedure details ● JDK 7
- 3.
- 4.
- 5.
- 6.
- 7.
- 8.
- 9. Mule Configuration Flow GlobalConfigurains : <spring:beans> <spring:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" name="mssqlDataSource" destroy-method="close"> <spring:property name="username" value="${DS_DB_USER}" /> <spring:property name="password" value="${DS_DB_PASSWORD}" /> <spring:property name="url" value="${DS_DB_URL}" /> <spring:property name="driverClassName" value="${DB_DRIVER}" /> <spring:property name="removeAbandoned" value="true" /> <spring:property name="initialSize" value="1" /> <spring:property name="maxActive" value="3" /> <spring:property name="maxIdle" value="1" /> <spring:property name="maxWait" value="5000" /> </spring:bean> </spring:beans> <db:generic-config name="Generic_Database_Configuration" dataSource-ref="dataSource" doc:name="Generic Database Configuration"> <db:pooling-profile /> </db:generic-config>
- 10. Flow Source <flow name="mssqltestFlow1"doc:name="mssqltestFlow1"> <http:inbound-endpoint exchange-pattern="request-response" host="localhost" port="8081" doc:name="HTTP"/> <db:stored-procedure config-ref="Generic_Database_Configuration" doc:name="Database"> <db:parameterized-query><![CDATA[{call test.fetchResults(:id)}]]></db:parameterized-query> <db:in-param name="id" type="INTEGER" value="#[payload]"/> </db:stored-procedure> <logger message="#[payload.resultSet1]" level="INFO" doc:name="Logger"/> <json:object-to-json-transformer doc:name="Object to JSON"/> </flow>