Receiver JDBC

[former_member189441]

Hi

i am using sync send step to select data from JDBC.

if i execute the query..when no data i available in the table..wil it send empty response..??

if so i have to check whether the reponse message is empty or not..if not empty proceed further or stop the process..how can i check

Thanks

[former_member189441]

Hi Raj

i need to do using BPM..

Thanks

[justin_santhanam]

Murali,

Do you want to use BPM or without BPM?

raj.

[former_member189441]

Hi Abhishek

this count should happen before Transformation step and after sync send step..

Syncsend>Count number of rows>transformation

so before entering into the mapping it self we need to decide whether the message should enter in to the mapping or not based on the number of rows.

Thanks

[former_member200962]

Option1: Mapping for Response in Interface Determination

Or

Option2: Mapping in Transformation Step after SYNC Send and then the message goes into the actual (required) mapping program....just a bit of change in design....i would prefer option1

If in BPM --> Sync_Send --> Transformation(get_count) --> Switch(to check count) and the inside Switch the mapping.

Regards,

Abhishek.

[former_member189441]

Hi

is there any way to count number of rows that we have selected from JDBC

Thanks

[former_member200962]

Using Index function in the mapping program will help....did you checked this option?

[madhusudana_reddy2]

Assume the below is the BPM response message,

resultset

row 0...inbounded

name 0..1

empid 0..1

salary 0..1

after getting above response message to BPM check whether name ( may be primary key in table which is not null) is null or not. if it is not null then your message having response from table otherwise you got empty response into BPM. you can check this condition in BPM switch step

thanks & Regards,

madhu