Error for empty records in JDBC response

[Former Member]

Hi Friends,

I am doing Proxy to JDBC Synchronous scenario, if the zero number of records are read from the JDBC side incase of where condition fails, it throws the error, instead of sending the empty records.How to over come this.

Thanks

Prem

Edited by: Prem Kumar on Oct 3, 2008 12:14 PM

[Former Member]

answered

[Former Member]

Can you send the error information and data type structure

.

Regards,

Sreeni

[Former Member]

Check if you can validate the where condition in JDBC. While selecting the records for response, if no record found you can set a message get the response as "no records found!!".

[dharamveer_gaur2]

are u selecting record at JDBC reciever and sending back?

[Former Member]

Yes dharmveer,

I am getting the data back from jdbc receiver, its synchronous interface. i have tried with o..unbounded and also 1..unbounded, but its throwing the error.

thanks

Prem

[dharamveer_gaur2]

hi

If u r using PI 7.1 then use JDBC look up(This facility available in only PI 7.1). and Map particular message if no record found.