DB Sender Adapter:: What happens when no records found for SQL Query..?

[Former Member]

Hi all,

I don't have access to DB in my currnet landscape. so i want somebody to try this out and tell me the result..<b> Its very simple..</b>

When DB adapter is configured as sender and an SQL SELECT Query dosen't fetch any records from the DB, will some message reach the integration server..? if yes, what is the message format..?

<i><resultset>

<b><>??????</></b>

</resultset></i>

Thanks in advance

DJ

<b>(Points guarenteed)</b>

[Former Member · Accepted solution]

DJ,

When DB adapter is configured as sender and an SQL SELECT Query dosen't fetch any records from the DB, will some message reach the integration server..? if yes, what is the message format..?

when No records are found JDBC sender adapter does not send message to intergtion server.

it is polls the DB if their is any records are available it will pick up and form the structure other wise it does not perform anything it such polls and keeps quiet no record structure is formed.

if you still have any quires post again.

regards

Sreeram.G.Reddy

[udo_martens]

Hi DJ,

no, no msg will be sent to IS in case of resultset is null.

Regards,

Udo