Skip to Content
avatar image
Former Member

JDBC 2 RFC Scenario

Hi Experts,

I have a scenrio JDBC -PI7.1- RFC syn. I got a table in JDBC . First i have to read the table and responce i need to update back to same table..

Jdbc table:

H Delivery no stutus cust addre XX XXXXX XX XXXXX

D Delivery no XXXX XXX XXXX 10 materail1 10 100.00

D Delivery no XXXX XXX XXXX 20 material2 20 200.00

D Delivery no XXXX XXX XXXX 30 maserial3 3 300.00

H

D

D

H :header D: details XX: empty space

If the table is like that. How can i create sturucture in PI as source side ?

What are the steps need to follow for RFC to JDBC syn scenrio ?

Note : In the table H D D ,like that repeating headers and items

Do you recomend , change request from oracle structure ?

Regards,

vasu

Edited by: vasudeva gembali on Sep 22, 2010 4:51 AM

Edited by: vasudeva gembali on Sep 22, 2010 4:54 AM

Edited by: vasudeva gembali on Sep 22, 2010 4:55 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 22, 2010 at 03:17 AM

    Hi Vasu,

    you will read the data from DB Table and will sedn it to RFC,RFC response will be send it JDBC,tjis is your requirement right??

    JDBCsender adapter will not support Synchronous mode,so you have to think ither option to use BPM.

    Regards,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2010 at 03:21 AM

    As I understood your query,

    you have two tables one is header and second is detail, in that you can use the combine structure in PI and use join query in sender adapter.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 22, 2010 at 04:16 AM

    Hi Vasudev,

    I understand the your requirement, JDBC to RFC synchronous scenario. Generally JDBC not preferred the Synchronous support.

    You can go for BPM for this

    Receive---Send(synchronous)- Send(asyn).

    These steps are enough for this scenario.

    But about your table, I am n't understand clearly, Kindly tell the column fileds.

    Thank you.

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vasudev,

      I didn't find any difference for this table and normal table.

      So you can create source datatype below format

      for ex:

      DT_vasudev

      --row 0 to unbounded

      -


      DELIVERY_ID 0 to 1

      -


      FLAG 0 to 1

      -


      CUstomerNo 0 to 1

      ...

      ....

      ......

      Thank you

      Sateesh