CA API DB conn

[Popleys]

Hi There,

Do CA API gateways perform JDBC query assertion supports calling a stored procedure?

thanks

[Christopher Waun]

Perform JDBC Query Assertion - CA API Gateway - 9.3 - CA Technologies Documentation 

 

About half way down the page is the section on calling functions and stored procedures. 

 

Hope this helps. 

[Popleys]

I am trying to get the count of an table using perform jdbc query assertion, it is expected to return approximately between 8k-10k records count.In this case, is it suggested to write a sql curry i,e select statement in the JDBC text box or call a stored procedure?

select count(*) from employee.

[Stephen Hughes]

Either will work to achieve the results you are looking for. I would probably avoid a stored procedure for this simple query.

 

Sincerely,

 

Stephen Hughes

Broadcom Support