JDBC Sender without Update Statement

[baskar_ramasamy]

Hi Experts,

i have a scenario to fetch data from oracle db table and dont have permission to update the table. in jdbc adapter channel select & update statement is mandatory.

if i put "-" in update statement field. data is not getting fetched from oracle db and throwing error in rwb logs.

in this case how to fetch the data from oracle without using update statement.

Regards,

Baskar

[Former Member · Accepted solution]

Hi ,

>>in jdbc adapter channel select & update statement is mandatory.

Update is not mandatory.If you don't want to update then mention as <TEST> in Update SQL statement.

Regards

Venkat

[Harish]

Hi Bhaskar,

AFAIK - update statement is req in sender jdbc, please refer below help page

Configuring the Sender JDBC Adapter - Advanced Adapter Engine - SAP Library

regards,

Harish