Error in reciever JDBC Adapater

[Former Member]

I have a select query as

SELECT * FROM ULIDTA2.F5631505 where QSINTF ='Y'

update query is

Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'

if there are no rows to update , i am getting a error. wht could be the issue .

[Former Member]

Hi Amit,

A JDBC sender adapter has 2 essential fields,

1. SQL Statement

2. Update Statement

Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just check these links to understand how JDBC adapters work,

If you wanna do update/insert you will have to follow the

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

For Configuring the Receiver JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter</a>

For Configuring the Sender JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter</a>

Regards,

Abhy

[Former Member]

This is the error i am getting

Sender Adapter v2108 for Party '', Service 'BS_Database_to_RFC_BPM':

Configured at 2006-03-10 12:31:18 GMT+08:00

History:

- 2006-03-10 12:33:06 GMT+08:00: Retry interval started. Length: 60.000 s

- 2006-03-10 12:33:05 GMT+08:00: Error: SQLException during update 'Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'': SQLException: [SQL7008] F5631505 in ULIDTA2 not valid for operation.

- 2006-03-10 12:33:00 GMT+08:00: Processing started

- 2006-03-10 12:32:05 GMT+08:00: Error: SQLException during update 'Update ULIDTA2.F5631505 set QSINTF='Y' where QSINTF ='N'': SQLException: [SQL7008] F5631505 in ULIDTA2 not valid for operation.

- 2006-03-10 12:32:00 GMT+08:00: Processing started