ContributionsMost RecentMost LikesSolutionsRe: Groovy's Sql broken after update to Ready API 3.1 Hirichie, I have tried INSERT via JDBC but to my knowlege you can't get the value of generated column back from the insert via JDBC step or by using DataSource step. We also don't support creating this data through HTTP API unfortunately. Re: Parametrized JDBC broken in Ready API 3.1 Hirichie, 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:smileyhappy: Parametrized JDBC broken in Ready API 3.1 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. SolvedGroovy's Sql broken after update to Ready API 3.1 I have a Test Case where I need to first insert a row into an Oracle DB and then I need to do something with it. To solve that I have used a Groovy script Test Step to insert a row using groovy.sql.Sql class and then retrieve the autogenerated column. In Ready API 3.0 this worked: import groovy.sql.Sql def driver = 'oracle.jdbc.driver.OracleDriver' com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( driver ) def col = null Sql.withInstance('what', 'ev', 'er', driver) { sql -> //below values are not really important, we just need some data def val1 = 1 def val2 = 2 String[] keys = ["COL"] def result = sql.executeInsert ("""insert into MY_TABLE (COL1, COL2) values ($val1 , $val2)""", keys) col = result[0].COL log.info("Inserted row with col=$col") } assert col != null return col However in Ready API 3.1 this gives me an error. After many tries I could not figure out how to do an insert with parameters and specifying column names to return. None of the overloads of executeInsert method worked. So I think it is a BUG that this code does not work in Ready API 3.1. Is there any other suggested method of inserting rows into DB and retrieving values of columns generated by the DB ? Solved