Camel SQL Insert From Select

Asked Apr 19 '18 at 07:44

Active Apr 19 '18 at 08:59

Viewed 331 times

I am using camel spring dsl to insert data into the database.

This is the code I am using:

camel:to uri=
   "sql:INSERT INTO SOME_TABLE(COL1,COL2) SELECT A.COL1,B.COL2 FROM A,B WHERE SOME_CONDITION"?dataSource="SOME_DataSource"

I am not getting any errors, but the data is not being inserted into the database table. Any idea on why this is happening and what I can do to solve this behavior?

edited Apr 19 '18 at 08:59

asked Apr 19 '18 at 07:44

Sarang

Which database you are using, if you are using oracle. It might check for commit statement. – Lucifer Apr 20 '18 at 10:30
Or there is no data matching the where clause. – Namphibian Apr 23 '18 at 22:06

Camel SQL Insert From Select

0 Answers0