RFC to JDBC Scenario

[deepak_shah]

Hi,

I am trying a syncronous RFC to JBDC scenario wherein i send data to JDBC tables and i response i m gettin the count of number of records that are inserted

The scenario works fine if i try to Insert a new record.

But when i send the same records again its givin followin error message in r/3

"com.sap.aii.af.ra.ms.api.DeliveryException"

In RWB communication channel monitor i get followin

"Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'QSTAG_OW_OSS' (structure 'Statement1'): java.sql.SQLException: General error"

Can this be capture in Alerts

please tell me how to handle this exception.

Thanks & Regards

Deepak shah

[vijay_kumar133 · Accepted solution]

Hi,

This error comes when ever the data is not inserted into tables by any reason,

like table name is wrong or filed name is wrong.. and

here in ur case the table is not alowed for duplicate records.. so try to send new records and check..i hope it will work for that..

com.sap.aii.af.ra.ms.api.DeliveryException"

this exception is data is not inserted.. so check the query.. or use update_insert with filed as key then u will get responce as number of inserted and number of updated records....

Regards

Vijay