Prerequisite: deployed MySQL JDBC driver

1. Data Type and Message Type for JDBC receiver

2. Mapping example (ABAP Proxy to JDBC Adapter)

3. Sender program

REPORT  ZSUNBN_JDBC_02.
PARAMETERS:
  P_NAME TYPE CHAR10,
  P_AGE  TYPE INT4.
START-OF-SELECTION.
  PERFORM FRM_OUTPUT.
FORM FRM_OUTPUT.
  DATA:
    i_proxy_obj     TYPE REF TO ZPICO_SI_SAMPLE_O,
    i_fault         TYPE REF TO cx_ai_system_fault,
    row_data        TYPE ZPIDT_SAMPLE_1_PEOPLE,
    import_para     TYPE ZPIMT_SAMPLE_1,
    i_text(255)     TYPE c,
    i_count         TYPE i.
  IF P_NAME IS NOT INITIAL.
    ROW_DATA-NAME = P_NAME.
    ROW_DATA-AGE = P_AGE.
    APPEND ROW_DATA TO IMPORT_PARA-MT_SAMPLE_1-PEOPLE.
    TRY.
      CREATE OBJECT I_PROXY_OBJ.
      CALL METHOD I_PROXY_OBJ->SI_SAMPLE_O
        EXPORTING OUTPUT = IMPORT_PARA.
      CATCH cx_ai_system_fault.
        CREATE OBJECT i_fault.
        i_text = i_fault->get_text( ).
    ENDTRY.
    COMMIT WORK.
    IF I_TEXT IS INITIAL.
      WRITE:/ 'OK'.
    ELSE.
      WRITE:/ I_TEXT.
    ENDIF.
  ENDIF.
ENDFORM.

4. Payload on Sender Side

5. Payload on Receiver Side

--EOF--