ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Broadcom API Gateway - JDBC Connections hangs in "testing"

book

Article ID: 238684

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

Customers have reported an issue with the TEST function in the Manage JDBC Connection configuration window.

Under specific conditions, the TEST operation hangs in "Testing" for a long time and even when the CANCEL button is pressed, the connection will remain in a busy state.

 

Cause

The issue is caused by the underlying c3p0 connection not timing out in a reasonable time period for cases where connectivity between Gateway and the remote Database are affected by an ongoing issue (for example a Firewall rule not allowing full communication between the two parties).

Environment

Release : 10.1

Component : API GATEWAY

Resolution

Solution is to enforce a timeout via c3p0.checkoutTimeout property.

  • Open Manage JDBC Connection in Policy Manager and edit the affected JDBC connection.
  • In the configuration window, click on ADD (1) button in the Additional Properties 
  • Set a new property (2) with the following values:

Property Name (case sensitive): checkoutTimeout
Property Value (milliseconds): 5000

  • The new property should show in the list as shown in the screenshot below (3)

 

Additional Information

c3p0.checkoutTimeout reference: https://www.mchange.com/projects/c3p0/#checkoutTimeout

Attachments