<?xml version="1.0" encoding="UTF-8"?>
<blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0"
xmlns:camel="http://camel.apache.org/schema/blueprint"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.osgi.org/xmlns/blueprint/v1.0.0 http://www.osgi.org/xmlns/blueprint/v1.0.0/blueprint.xsd        http://camel.apache.org/schema/blueprint http://camel.apache.org/schema/blueprint/camel-blueprint.xsd">
<!-- this is the JDBC data source Config for postgresql database -->
<bean class="org.apache.commons.dbcp.BasicDataSource"
    destroy-method="close" id="dataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/demo"/>
    <property name="username" value="root"/>
    <property name="password" value="root"/>
</bean>
<!-- configure the Camel SQL component to use the JDBC data source -->
<bean class="org.apache.camel.component.sql.SqlComponent" id="sql">
    <property name="dataSource" ref="dataSource"/>
</bean>
<camelContext id="CustInfoContext" trace="false" xmlns="http://camel.apache.org/schema/blueprint">
    <propertyPlaceholder id="properties" location="classpath:sql.properties"/>
    <route customId="true" id="custinfoRoute">
        <from id="_from1" uri="activemq:queue:customer"/>
        <unmarshal id="_unmarshal1">
            <jaxb contextPath="org.blogdemo.homeloan.model"
                partClass="org.blogdemo.homeloan.model.CustInfo" prettyPrint="true"/>
        </unmarshal>
        <setHeader headerName="custNationalID" id="_setHeader1">
            <simple>${body.nationalID}</simple>
        </setHeader>
        <setHeader headerName="firstName" id="_setHeader2">
            <simple>${body.firstName}</simple>
        </setHeader>
        <setHeader headerName="lastName" id="_setHeader3">
            <simple>${body.lastName}</simple>
        </setHeader>
        <setHeader headerName="age" id="_setHeader4">
            <simple>${body.age}</simple>
        </setHeader>
        <setHeader headerName="occupation" id="_setHeader5">
            <simple>${body.occupation}</simple>
        </setHeader>
        <to id="_to1" uri="sql:{{sql.insertCustInfo}}"/>
    </route>
</camelContext>