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

book

Article ID: 222361

calendar_today

Updated On:

Products

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

Issue/Introduction

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.

Environment

Release : 9.4

Component :

Resolution

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)