can we use regex function in JDBC test step
Hi, I am using open source SoapUI tool . trying to retrieve DB result using JDBC step. Below is the query, I used -SELECTregexp_replace(current_bill_cycle_amount::text,'^(-??\\d*?\\.\\d*?)0*\$','\1')current_bill_cycle_amountfrom liability.creditcardstatement ; getting error message as -Tue Sep 13 14:32:07 IST 2016:ERROR:org.postgresql.util.PSQLException: No value specified for parameter 1. DBName - PostgreSQL When I tried wothout regex function, i am getting response from DB. Any one please suggest, whether I can use regex function in JDBC step or not. Same query is working in postgresql and getting expected response.