Ibatis and polling database

I would like to use IBatis for polling 3 legacy databases for new rows an开发者_运维问答d insert into a new database. But our customers don't allow me to insert one "status" column in three legacy databases which help me avoid consuming twice or more. So what do I have to do? Thanks in advance!

---

Create a new table with the status column and add a foreign key pointing to the primary key of the legacy table. Create a view with both tables joined together and you will have your status column associated with the legacy table without altering it.

---

You can use the idempotent consumer EIP to filter out duplicates http://camel.apache.org/idempotent-consumer.html

But as Joachim said, you need a new table to store the status.

You can maybe also create a SQL VIEW on the original table + status table, and let iBatis query that view.