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

Products

• CA API Gateway
• API SECURITY
• 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)