Re: CamelSqlUpdateCount is negative value??

[Claus Ibsen <cl...@gmail.com>]

The SQL component stores the update count what was returned from the JDBC call.

Not sure what a -60 value would mean. But check with the vendor of the
database and see what a negative value could mean.



On Thu, May 12, 2016 at 10:36 AM, sungkwon.eom <sk...@gmail.com> wrote:
> Hello,
>
> Below is my route code for oracle update.
>
> I want to get the number of updated records.
>
> ===============================
> from("seda:db_upadte?size=10&concurrentConsumers=4&blockWhenFull=true").startupOrder(30)
>                         .to("sql:update tr_vdis_trace set V_ETAS = # WHERE P_TRIPSEQ =# and
> P_FST_TIME = #?batch=true&dataSource=myDataSource")
>                         .log("=${header.CamelSqlUpdateCount}  records updated-!!")
>                         .log("=${header.CamelSqlQuery}")
>                         .log("${body}")
>                        .end();
>
> =================================
>
> I checked that the DB data was updated successfully.
> BUT CamelSqlUpdateCount is negative value (-60).
> What is wrong? Should I do something more to get right value?
>
>
> thanks.
>
> ================header values===============================
> seda://db_upadte |
> ={breadcrumbId=ID-eomseong-gwon-ui-MacBook-Pro-local-57167-1463041216709-0-3,
> CamelFileAbsolute=true,
> CamelFileAbsolutePath=/var/folders/60/gz5nf__d5r11htj9q2zxk9qw0000gn/T/camel1662256863897921216.tar,
> CamelFileLastModified=1463041218000, CamelFileLength=2334720,
> CamelFileName=Real.20160512172019037_3.tar.gz,
> CamelFileNameConsumed=camel1662256863897921216.tar,
> CamelFileNameOnly=camel1662256863897921216.tar,
> CamelFileNameProduced=temp/Real.20160512172019037_3.tar.gz,
> CamelFileParent=/var/folders/60/gz5nf__d5r11htj9q2zxk9qw0000gn/T,
> CamelFilePath=/var/folders/60/gz5nf__d5r11htj9q2zxk9qw0000gn/T/camel1662256863897921216.tar,
> CamelFileRelativePath=camel1662256863897921216.tar, CamelFtpReplyCode=226,
> CamelFtpReplyString=226 Transfer complete.
> , *CamelSqlUpdateCount=-60*, COMPRESS_ID=COMPRESS,
> REAL_AGGREGATION_ID=REAL_AGGREGATION}
>
>
>
> --
> View this message in context: http://camel.465427.n5.nabble.com/CamelSqlUpdateCount-is-negative-value-tp5782476.html
> Sent from the Camel - Users mailing list archive at Nabble.com.



-- 
Claus Ibsen
-----------------
http://davsclaus.com @davsclaus
Camel in Action 2: https://www.manning.com/ibsen2