ABAP Proxy to JDBC syncronous method

[Former Member]

Hi Experts,

I am very new to ABAP Proxy to JDBC syncronous method.

I have used 4 DT, 4 MT, 2 MI, 2 MM and 1 IM.

I have used reference from

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3928. [original link is broken] [original link is broken]

My question is in Integration Directory how many sender agrement, receiver agrement, receiver determination and interface determination should i use?

Is my above DT , MT , MI , MM and IM is correct?

I am not using any BPM.

Thank you in advanced.

regards,

S.Saravannan

[Shabarish_Nair · Accepted solution]

> My question is in Integration Directory how many sender agrement, receiver agrement, receiver determination and interface determination should i use?

for a Sync sceanrio, you will create

1 RD

1 ID

1 SA (since its a ABAP proxy call this is optional)

1 RA

> 
> Is my above DT , MT , MI , MM and IM is correct?

Yes

[Former Member · Accepted solution]

HI all,

I have used as per your advise. I had changed the scenario from File to JDBC for Testing purpose for the client.

If my file sender in a different location and the response should be back to a different location.

example:

File CC shold be 2 because one for sender CC and Receiver CC. Is it YES?

Question: But JDBC will be 1 or 2 CC?

Currently the the result is perfect RWB but i dont see any response?

Please guide me.

Thank you.

[rajasekhar_reddy14 · Accepted solution]

JDBC receive channel works as a sync mode one receiver channel enough but File adapter will not support sync comunication thats why no response.

testing purpose use SOAP in sedner side it should work.

Regards,

Raj

[Former Member · Accepted solution]

Hi Mr Raja,

As per your advice, the sender has been changed to Proxy and receiver remain as JDBC.

I can see success message at RWB but still i dont see any response message.

Please refe to my XML at the payload.

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:MT_REC_JDBC xmlns:ns0="urn://testJDBC">

<STATEMENT>

<TABLENAME ACTION="SQL_QUERY">

<TABLE>BTSTEST</TABLE>

<ACCESS>

<TICKETNO>123</TICKETNO>

</ACCESS>

</TABLENAME>

</STATEMENT>

</ns0:MT_REC_JDBC>

Hope to see your reply and it is very important your help.

Thank you.

s.saravannan

[rajasekhar_reddy14 · Accepted solution]

Hi ,

Use sender side SOAP(testing puporse) and test your idevelopment using SOAP UI or WS Nvigtor.

Hoping that development done correctly.

Regards,

Raj

[Former Member · Accepted solution]

please cross check the SQL_QUERY Statement and make sure that the response structure is correct??

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/747eda12dd3676e10000000a114a6b/frameset.htm

[Former Member · Accepted solution]

Hi Experts,

I managed to solve the problem with your helps.

I had changed the scenario as JDBC will be the sender and i managed to pull the data from Oracle tables.

Thank you,

regardss,

S.Saravannan

[Former Member]

>>how many sender agrement, receiver agrement, receiver determination and interface determination should i use

1 Receiver Determination,1 Interface Determination , 1 Receiver Agreement and 1 receiver JDBC channel

Since you are using proxy so you dont need create the sender agreemnet and sender CC