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 - 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.