Duplicate data inserted into Oracle database by "Insert JDBC Data in Bulk" assertion


Article ID: 222361


Updated On:


CA API Gateway API SECURITY CA API Gateway Enterprise Service Manager (Layer 7) CA Mobile API Gateway CA Rapid App Security STARTER PACK-7


Use the "Insert JDBC Data in Bulk" assertion to insert data into Oracle database but often insert duplicate data.

Not all the data is repeated, and the amount is different each time.

For example,

Tried to insert 2000 data, but the actual amount be inserted into the database is 3800, 3900, or some other amount.


Release : 9.4

Component :


This is seen in gateway 9.4 without CR patch, the problem fixed after apply gateway CR05

(it's likely due to the CR05 upgrades the Oracle jdbc driver from 5.1.4 to 6.0.0)