cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Synchronous scenario

ravi_reddy1
Participant
0 Kudos

Hi Folks,

My scenario is JDBC synchronous (JDBC<-->PI<-->Proxy).

My question is

1) how to develop this scenario with out BPM's?

2) if we use Req and Res beans , where we need to add these parameters (sender or receiver jdbc channel?) ?

Regards,

Ravi

Accepted Solutions (1)

Accepted Solutions (1)

former_member237514
Participant
0 Kudos

Hi Ravi,

For 2nd ques answer.

your scenario is JDBC --->Proxy so u need proxy response to back so,

you need to config the req and response bans in sender JDBC channel only .

plz check sample config screen shot

ravi_reddy1
Participant
0 Kudos

Hi Kavita,

Apart from these beans, shall i need to write a code?

could u please elaborate me?

Regards,

Ravi

former_member237514
Participant
0 Kudos

Hi Ravi,

I think you need to do some coding in proxy side i am nt sure about that,

But while config Beans and all no need to do coding in JDBC side.

Thanks

Kavitha

Answers (2)

Answers (2)

ravi_reddy1
Participant
0 Kudos

hi,

give some idea please

iaki_vila
Active Contributor
0 Kudos

Hi Ravi,

I suppose you know that the sender JDBC adapter has an UPDATE after the SELECT, but i think you will need some data from SAP ECC to update later. There is the possibility with async/sync bridge: depending your PI version. Another way,especially if the ECC processing is large you can opt to do two scenarios, in this way you can control easilly in ECC a possible issue in the update with Async (jdbc)-Async(proxy) and Sync(proxy)-sync(jdbc) scenarios.

Regards.

ravi_reddy1
Participant
0 Kudos

Hi Vila,

Suppose if i use modules, is it necessary to  write the code against the modules?

if code is needed where i needs to write the code?

Regards,

Ravi

iaki_vila
Active Contributor
0 Kudos

Hi Ravi,

To use these modules you don't need extra java code, you only have to prepare correctly the module tab and to have in mind their scope. This link has more examples: http://saprainbow.com/wordpress/wp-content/uploads/2015/06/AsyncSync_and_SyncAsync_Bridge_without_BP...

Regards.

ravi_reddy1
Participant
0 Kudos

HI Vila,

can i split 2 interfaces (2 async) for this requirement?

Please help me this approach is possible or not?

Regards,

Ravi

dipaks_patil
Explorer
0 Kudos

Hi Ravi,

You can split scenario in 2 interfaces.

1) JDBC To Proxy (async)

2) Proxy To JDBC (async)

Ask abaper to call 2nd interface outbound proxy class (create object of class and pass value in OUTPUT structure) in 1st interface inbound proxy coding .

Thanks,

Dipak Patil