JDBC DYN Connector cannot invoke MySQL Stored Procedure as Operation Binding

Products

• CA Identity Manager

Issue/Introduction

After configuring the initial setup of a JDBC DYN Connector against MySQL server using Connector Xpress, creating Stored Procedure Operation Binding doesn't show expected dialog.
Created Stored Procedure item under Operation Bindings node stays like below screen and clicking it doesn't show correct dialog where existing Stored Procedures can be selected.

Environment

Release : 14.3

Component : Identity Manager

Cause

Connector Xpress does not support Stored Procedure for MySQL or Informix

Resolution

Stored Procedure Operation Binding for MySQL is not supported. The following document describes it.

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-management-and-governance-connectors/1-0/connectors/dynamic-connectors-connector-xpress/troubleshooting-connector-xpress.html#concept.dita_32206ad0d02721e5804eff34fadacf48d144b205_MySQLandInformixStoredProcedureSupport

Quoted from document above:

Connector Xpress does not support the following stored procedures from the following vendors:

MySQL

 - MySQL stored procedure parameters are not accessible through the required JDBC method and therefore are not supported.

 

You can try to work around running Script as Operation Binding or utilize PX Policy to achieve your objective.