How to eliminate inserting Duplicate rows into database using JDBC Adapter

[#1]

File->Xi->JDBC

In above Scenario if the file has two rows their values are identical, then how can we eliminated inserting Duplicate rows into database using JDBC Adapter

[Former Member]

Hi

Duplicate Insertions can be handled at the DB level only when yo have a primary key set in the table.

Only then it will automatically not allow such insertions

Otherwise you need to do the checks at the Mapping level.

Thanks

[Former Member]

Database is a consumer of a SERVICE (SOA!!!!!!).

Database plays a business system role here!!!!

Mapping is part of an ESB service

Adaptor is a technology adapted to ESB framework to support specific protocol.

ESB accomplish ESB duties such as transformation, translation, routing. Routing use a protocol accepted by the consumer. In a JDBC consumer it is JDBC protocol and hence it a JDBC adaptor.

There is clear separation on responsibilities among business system and ESB. ESB do not participate in business decision or try to get into business system data layer.

So who ever are asking people to check duplicate check as part of mapping (an ESB service) may not understand integration practice.

Please use an adaptor module which will execute the duplicate check with business system in a plug and play approach and separate that from ESB service so that people can build integration using AGILE approach.

Thanks