How to ignore the update sql statement in JDBC communication channel

[Bhargavakrishna]

Hi Experts.

As per our requirement, i only have a authorizations to read the data from the database.i can only able to write select query. so i was unable to write the update query in my JDBC sender communication channel. so how can i handle this issue. please provide your valuable inputs to overcome this issue.

[Former Member]

Hi ,

In sender channel if you don't want to update the table after executing the select query;put as below in sender JDBC channel.

Update SQL Statement  <TEST>

Regards

Venkat

[Bhargavakrishna]

Thank you..