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.

Issue with JDBC connection on CA API GW

book

Article ID: 187214

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

We have CA API GW 9.4 CR 04 RHEL appliance in our environment. We are connecting to MYSQL of CA API GW from policy manager using JDBC connections. We are executing "show slave status" query from JDBC connection. However we are getting zero rows in result

 

Environment

Release : 9.4

Component : API GATEWAY

Resolution

What we determined is the call “show slave status” is not a query to a table it’s a function call to check the status JDBC query will only return 0 or -1 from this call because there is no table for the data

It suggested to use ssg/ping if possible it returns the replication status note also many other gateway status