API Gateway no response when try to update Oracle database

book

Article ID: 209850

calendar_today

Updated On:

Products

CA API Gateway STARTER PACK-7 CA Mobile API Gateway API SECURITY CA Rapid App Security

Issue/Introduction

When use JDBC query assertion to update db(Oracle) directly, can't get any response.

 

can't get response and stuck here

 

Cause

There is another transaction running on backend, and it's not committed yet. The raw is locked and the gateway is waiting for the lock.

Environment

Release : 10.0

Component : API GATEWAY

Resolution

Oracle SQL developer or SQL plus is not auto commit by default, need to manually commit/rollback to release the lock.