title: Data insert into DB using Mule esb
body: <p>I want to do some POC, in this I taken data from the Rest api. I am getting data in Json format, then put in one text file. Now I try to that file data in DB. Below find the XML format of Mule flow.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  
  &lt;mule xmlns:file="http://www.mulesoft.org/schema/mule/file" xmlns:metadata="http://www.mulesoft.org/schema/mule/metadata" xmlns:json="http://www.mulesoft.org/schema/mule/json" xmlns:dw="http://www.mulesoft.org/schema/mule/ee/dw" xmlns:db="http://www.mulesoft.org/schema/mule/db" xmlns:http="http://www.mulesoft.org/schema/mule/http" 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" 
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-current.xsd
  http://www.mulesoft.org/schema/mule/db http://www.mulesoft.org/schema/mule/db/current/mule-db.xsd
  http://www.mulesoft.org/schema/mule/http http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
  http://www.mulesoft.org/schema/mule/ee/dw http://www.mulesoft.org/schema/mule/ee/dw/current/dw.xsd
  http://www.mulesoft.org/schema/mule/core http://www.mulesoft.org/schema/mule/core/current/mule.xsd
  http://www.mulesoft.org/schema/mule/json http://www.mulesoft.org/schema/mule/json/current/mule-json.xsd
  http://www.mulesoft.org/schema/mule/file http://www.mulesoft.org/schema/mule/file/current/mule-file.xsd"&gt;
      &lt;http:listener-config name="HTTP_Listener_Configuration" host="0.0.0.0" port="8082" doc:name="HTTP Listener Configuration"/&gt;
      &lt;http:request-config name="HTTP_Request_Configuration" host="$host" port="$port" doc:name="HTTP Request Configuration"/&gt;
      &lt;db:generic-config name="Generic_Database_Configuration" url="localDB Connection" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" doc:name="Generic Database Configuration"/&gt;
      &lt;file:connector name="File" autoDelete="true" streaming="true" validateConnections="true" doc:name="File"/&gt;
  
      &lt;flow name="Flowname"&gt;
          &lt;http:listener config-ref="HTTP_Listener_Configuration" path="/Customer" doc:name="HTTP" /&gt;
          &lt;http:request config-ref="HTTP_Request_Configuration" path="/Services/Customers/api/2.0/search/{a}" method="GET" doc:name="HTTP"&gt;
              &lt;http:request-builder&gt;
                  &lt;http:uri-param paramName="a" value="s"/&gt;
              &lt;/http:request-builder&gt;
          &lt;/http:request&gt;
          &lt;file:outbound-endpoint path="D:\Docs" outputPattern="test.txt" responseTimeout="10000" doc:name="File"/&gt;
          &lt;json:json-to-object-transformer returnClass="java.util.HashMap" mimeType="text/plain" doc:name="JSON to Object"/&gt;
          &lt;logger message="#[message.payload]" level="INFO" doc:name="Logger"/&gt;
          &lt;set-payload value="#[message.payload.CustomerID],#[message.payload.Address],#[message.payload.DOB],#[message.payload.FirstName],#[message.payload.LastName],#[message.payload.MiddleName],#[message.payload.PhoneNo]" doc:name="Set Payload"/&gt;
          &lt;db:insert config-ref="Generic_Database_Configuration" doc:name="Database"&gt;
              &lt;db:parameterized-query&gt;&lt;![CDATA[INSERT INTO dbo.tblCustomer (Customerid,Address,Dob,Firstname,LastName,Middlename,Phoneno) VALUES (#[Message.payload.CustomerID],#[Message.payload.Address],#[Message.payload.DOB],#[Message.payload.FirstName],#[Message.payload.LastName],#[Message.payload.MiddleName],#[Message.payload.PhoneNo])]]&gt;&lt;/db:parameterized-query&gt;
          &lt;/db:insert&gt;
      &lt;/flow&gt;
  &lt;/mule&gt;
  </code></pre>
  
  <p><strong>Getting data from Service like this</strong></p>
  
  <pre><code>[{
      "Address": "372 Willene Drive",
      "CustomerID": 1010007031,
      "DOB": "1981-09-19",
      "FirstName": "Aaliyah",
      "LastName": "Gonzalez",
      "MiddleName": "R",
      "PhoneNumber": "7775271592"
  }, {
      "Address": null,
      "CustomerID": 1010007743,
      "DOB": "1937-05-28",
      "FirstName": "Aaron",
      "LastName": "Green",
      "MiddleName": "T",
      "PhoneNumber": "0924758727"
  }, {
      "Address": "7 Country Lake Drive",
      "CustomerID": 1010004653,
      "DOB": "1936-03-07",
      "FirstName": "Aaron",
      "LastName": "Gutierrez",
      "MiddleName": "Q",
      "PhoneNumber": "9919500942"
  }, {
      "Address": "157 Tamir Avenue",
      "CustomerID": 1010005851,
      "DOB": "1955-12-19",
      "FirstName": "Abigail",
      "LastName": "Garcia",
      "MiddleName": "G",
      "PhoneNumber": "4695049914"
  }, {
      "Address": "5 Cross Road",
      "CustomerID": 1010007962,
      "DOB": "1939-07-23",
      "FirstName": "Abigail",
      "LastName": "Gomez",
      "MiddleName": "R",
      "PhoneNumber": "6267010014"
  }]
  </code></pre>
  
  <p>Could you please help on this.</p>