camel jdbc 执行SQL语句

导入pom文件

<dependency>
    <groupId>org.apache.camel</groupId>
    <artifactId>camel-jdbc</artifactId>
    <version>2.17.3</version>
</dependency>

spring中配置数据源

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
        init-method="init" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="initialSize" value="${jdbc.initialSize}" />
        <property name="minIdle" value="${jdbc.minIdle}" />
        <property name="maxActive" value="${jdbc.maxActive}" />
        <property name="maxWait" value="${jdbc.maxWait}" />
        <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}" />
        <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}" />
        <property name="validationQuery" value="${jdbc.validationQuery}" />
        <property name="testWhileIdle" value="${jdbc.testWhileIdle}" />
        <property name="testOnBorrow" value="${jdbc.testOnBorrow}" />
        <property name="testOnReturn" value="${jdbc.testOnReturn}" />
        <property name="poolPreparedStatements" value="${jdbc.poolPreparedStatements}" />
        <property name="maxPoolPreparedStatementPerConnectionSize"
            value="${jdbc.maxPoolPreparedStatementPerConnectionSize}" />
    </bean>

如何在camel中使用

<!-- camel配置 -->
<camelContext id="camelContext" xmlns="http://camel.apache.org/schema/spring">
    <propertyPlaceholder id="camelProperties"
        location="classpath:camel.properties" />

    <route id="quartz">
        <from uri="jetty:http://{{ip}}:{{port}}/jdbc" />
        <removeHeaders pattern="CamelHttpUri"/>
        <to uri="bean:jdbcBean?method=packSql" />
        <to uri="jdbc:dataSource?resetAutoCommit=false"/>
        <to uri="bean:jdbcBean?method=logTime" />
    </route>

</camelContext>

解释

<to uri="jdbc:dataSource?resetAutoCommit=false"/>

jdbc标识jdbc路由，是导入camel-jdbc才有的，dataSource是数据源bean的id