cancel
Showing results for 
Search instead for 
Did you mean: 

Synch Scenario ( RFC to JDBC)

Former Member
0 Kudos

Hi,

I have a synch scenario like RFC to JDBC.

1. I have a qurey regarding JDBC receiver side structure. What would be the structure I have to create on receiver side ( JDBC) for the same.

2. Mainly, what would be the constants I have to map for the action, table, statement fileds??!! If possible try to explain for each and every scenario.( synch/asynch)

Cheers.,

Stallin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Stallin,

Please refer to <a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm">Document Formats for the Receiver JDBC Adapter</a> for more information on the document structure.

Kind regards,

Koen

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Stallin,

Check these links:

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

http://help.sap.com/saphelp_nw04s/helpdata/en/33/c6e63b60c25767e10000000a11402f/frameset.htm

Regards,

Subhasha Ranjan

Former Member
0 Kudos

Thanks...for the help

Former Member
0 Kudos

Hi ,

Format for JDBC request message

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<col1>val1</col1>

<col2>val2new</col2>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

<StatementName2>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<col1>val1</col1>

<col2>val2new</col2>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName2>

</root>

For instance you want to make sure that the records are corrected inserted/updated in database so you will design it as sync scenario where after inserting/updating data database will return you the insert or update count .

Response message structure will be like ,

<root>

<StatementName1>

<insert_count>

</insert_count>

</StatementName1>

<StatementName1>

<insert_count>

</insert_count>

</StatementName1>

</root>

Also you can refer to these blogs for sync/async implementation

Use of Synch - Asynch bridge in ccBPM

/people/sriram.vasudevan3/blog/2005/01/11/demonstrating-use-of-synchronous-asynchronous-bridge-to-integrate-synchronous-and-asynchronous-systems-using-ccbpm-in-sap-xi

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

Thanks ,

Suvarna

Award pts if it helps .

Former Member
0 Kudos

Hi,

For Action: INsert, Select, Update...

Statement: XYZ or the request

table: Table name..

regards

Hemant

Former Member
0 Kudos

Hi,

Go through this blog

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards

Hemant

Reward points if find helpful