How to eliminate inserting Duplicate rows into database using JDBC Adapter

[venky_b]

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

[venky_b]

Its been Solved

[prabhu_s2]

hi venkat

could u share with community on the solution.

[Former Member]

Hi Venkatesh,

Could u pls share the solution for this problem, bcoz i too faced the same problem.

Eagerly awaiting ur reply.

[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

[udo_martens]

Hi Venkatesh,

usually the DB handels that for itself, you cant insert 2 same rows as the keys would be same as well. You would get an error.

To avoid getting errors use action UPDATE_INSERT, double entries are now ignored.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

Regards,

Udo

[Former Member]

Hi

Check this

[former_member192892]

You can handle this situation in your mapping.

Best would be to use a java mapping, having the coding done to eliminate the duplicate records

[Former Member]

Usage of a custom adapter module at File adapter would greatly help here.

Inside the adapter module to every row add a field <status> and set its value to true or false based on first occurance or repeated value. Inside the mapping map only the records that have the value true for status field.

Regards,

Jai Shankar