I am using JDBC Test Step in SoapUI to select data from an Oracle database. My sql statement contains parameters and looks something like this:
select ID from MY_TABLE where REF_ID = :ref_id order by UPDATED_AT desc fetch first 1 rows only
The query contains ref_id parameter. I have defined the parameter in the configuration of the test step with valid value.
In Ready API 3.0 this worked fine. After update to Ready API 3.1 this does not work anymore. I am getting this error:
2020-02-19 10:10:46.912 - Error getting response; java.sql.SQLException: Missing IN or OUT parameter at index:: 1
When I replace the parameter in the query with specific value it works but I want to use parameters in my queries.
One thing to note is that when I open the JDBC's Query Builder using the Build Query button and I execute my query with parameters there it works as expected.
Solved! Go to Solution.
I have tried using the property references via Get Data and that works. Although even a simples use case with : parameter/alias doesn't. I can solve my problem with the property concatenation like you suggested but that is not the point. The parameters are there for a reason and if they don't work it is either a bug or the functionality should be removed
apologies - I thought you were looking for a workaround not just highlighting a possible issue.
Yeah - as I said before - best thing would be to raise a ticket with Smartbear so they're aware of the issue,