Forum Discussion

vinay86nagariya's avatar
Senior Member
8 years ago

can we use regex function in JDBC test step



I am using open source SoapUI tool . trying to retrieve  DB result using JDBC step. 


Below is the query, I used - SELECT regexp_replace(current_bill_cycle_amount::text,'^(-??\\d*?\\.\\d*?)0*\$','\1')current_bill_cycle_amount from 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.



No RepliesBe the first to reply