how to handle the jdbc receiver error

[former_member319973]

hi,expert:

I have a synchornous scenario:SAP/ECC(Proxy) to JDBC(SQLServer),ECC Send the message and insert data into the database,when insert sucessfully the receiver returns the count of the sucessfull inserted record . Not use store procedure.

I have a problem: When insert into the table occurs errors,like insert Duplicated record,how can i capture this exception and return to the ECC? And if it is possible to solve this problem by using fault message?

wait for reply ,thanks!

[rajasekhar_reddy14 · Accepted solution]

Have you identified why duplicate record error coming?? you dont want to insert duplicate records in DB?? then in this case you contraol sending data in Proxy it self,

If you want response (error message or success status from Data base you can design/develop easily, JDBC recv will support syn communication.

even you can go for fault message type to handle this error,

http://help.sap.com/erp2005_ehp_04/helpdata/EN/dd/b7623c6369f454e10000000a114084/content.htm

Regards,

Raj