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 <[email protected]> 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
