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.
