Forum Discussion

HEATConsultant's avatar
HEATConsultant
Occasional Contributor
6 years ago
Solved

Data Import from SQL Database

SOAP Newbie here.   Successfully created my first SOAP Project and request to create a record.   Now how can I do a mass import by getting the data from a SQL Database source file and then lo...
selva29's avatar
selva29
Occasional Contributor
6 years ago

Hi , 

 

I cant able to execute complex POSTGRES query form JDBC Request and get the response . same query is working fine in the POSTGRES console and get the result .

 

Is Soap ui accepts only the sql query , post-gres query are not working from jdbc request?, if so what will the solution for this? Please someone clarify 

 

query which i tried: 


select Max(NULLIF(regexp_replace(reference_id, '[^0-9.]*','','g'), '')::numeric)
from transactions as ref_id 

 

Thanks

 

Recent Discussions