SAP PI ABAP Proxy to JDBC Synchronous Interface Part IV

[former_member186494]

At the last part I will show that how to test this interface.

6. Test

We can test the abap proxy consumer in “SPROXY”

  

 

 

Or write some abap code to test the ABAP proxy consumer:

  data: lo_proxy type ref to zco_si_a2j.



 data: ls_outut type zmt_a2j_req,

 ls_input type zmt_a2j_res.



 data: wa_results type zdt_a2j_res_results.



 constants l_times type i value 10.



 create object lo_proxy.



 parameters p_empc type string DEFAULT '0010009151'.



 try.

      ls_outut-mt_a2j_req-emp_code = p_empc.



      call method lo_proxy->si_a2j

      exporting

           output = ls_outut

      importing

           input  = ls_input.



      commit work.



      write: / 'Success!'.

      loop at ls_input-mt_a2j_res-results into wa_results.

           write: / 'structurecode:', wa_results-scode.

           write: / 'empcode:', wa_results-empcode.

           write: / 'c_name:', wa_results-name.

           write: / 'parentid:', wa_results-pid.

           write: / 'superempcode:', wa_results-superempc.

           write: / 'defaultposition:', wa_results-defposit.

           write: / 'approve:', wa_results-approve.

      endloop.

      catch cx_ai_system_fault .

      data fault type ref to cx_ai_system_fault.

      create object fault.

      write 😕 fault->errortext.

 endtry.

7. Reference

JDBC Receiver scenarios best practices - Stored procedure design-Part4

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/07/jdbc-receiver-scenarios-best-prac...

JDBC Stored Procedures

http://scn.sap.com/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Defining XML Documents for Message Protocol XML SQL Format

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

Defining an EXECUTE Statement

http://help.sap.com/saphelp_nw74/helpdata/en/44/7b72b2fde93673e10000000a114a6b/content.htm

JDBC Receiver Adapter -- Synchronous Select – Step by Step

http://scn.sap.com/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select...

JDBC receiver adapter - stored procedure response

https://scn.sap.com/thread/2015436

Please contact me if there are some mistake in the documents or doubt.

Sorry for my poor Englist. :wink:

The links of other parts:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/09/02/sap-pi-abap-proxy-to-jdbc-synchro...