Skip to Content
author's profile photo Former Member
0
Former Member

JDBC 2 RFC Scenario

Posted on Sep 22, 2010 at 02:47 AM 13 Views

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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Raja Sekhar Reddy
    Raja Sekhar Reddy
    Posted on Sep 22, 2010 at 03:17 AM
    2

    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2010 at 03:21 AM
    0

    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 a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2010 at 04:16 AM
    0

    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 a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Sep 22, 2010 at 08:39 AM

      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

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.