camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix Thomas <>
Subject statement.maxRows not working as expected camel jdbc
Date Wed, 06 Jan 2016 15:04:06 GMT

      I have an issue (not sure if its a bug)  in camel. I have tested in
multiple versio*n i.e. 2.15.1,2.16.0,2.16.1 *also but still the same result.

      I have a route defined below in spring XML . When i start the camel
instance it works fine at the first time i.e it fetches only 2 records as
expected . But  when the timer kicks in after 1 minute again it fetchs all
the rows in the table . I expect it to fetch only 2 again. Is there an
issue in my route definition ??

<route customId="true" id="ROUTE_TBL_DATA_AC" xmlns="">
    <from uri="timer://getDataROUTE_TBL_DATA_AC?period=1m"/>
    <setBody id="setBody2">
        <constant>select * from TBL_DATA_AC</constant>

    <to uri="jdbc:DSROUTE_TBL_DATA_AC?*statement.maxRows=2&*amp;outputType=StreamList"
    <split parallelProcessing="true" streaming="true" id="split1">
        <convertBodyTo type="java.lang.String" />
        <multicast parallelProcessing="true"
executorServiceRef="customThreadPoolProfile" id="multicast1">
            <pipeline id="pipeline1">


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message