Issue with JDBC connection on CA API GW
search cancel

Issue with JDBC connection on CA API GW


Article ID: 187214


Updated On:


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


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



Release : 9.4

Component : API GATEWAY


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.  Nothing is returned l because there is no table data

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