jdbc ADAPTER

[naveen_chichili]

Hi Gurus,

I am doing File to JDBC Scenario , after inserting the into database i need to get the number of records count inserted into database as a response and if there is any errors then these errors has to be inserted into error tables in the same database could any please suggest the steps to be fallowed to achieve my requirement.As per my understanding i need to implement stored procedures .... do we have any other option other than that........

Please suggest the best way to achieve ...

if you have any blogs please suggest step by step.

Thanks in advance,

chichili.

[deepak_shah]

Hi,

Please check following blog link:

/people/arpil.gupta/blog/2008/11/03/workaround-for-jdbc-scenarios

Hope this helps.

Regards,

Deepak.

[Former Member]

Use stored procedure on the receiver side. According to me, that is the best option if you want response back from database.

Below are the blogs that help you to implement Synchronous JDBC adapter(receiver side) with stored procedure

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm