Layer7 API Management

Expand all | Collapse all

CA API DB conn

Jump to Best Answer
  • 1.  CA API DB conn

    Posted 04-20-2018 01:45 PM

    Hi There,

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

    thanks



  • 2.  Re: CA API DB conn

    Posted 04-23-2018 11:24 AM

    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. 



  • 3.  Re: CA API DB conn

    Posted 04-30-2018 09:30 PM

    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.



  • 4.  Re: CA API DB conn
    Best Answer

    Posted 11-24-2018 09:10 PM

    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