on 06-15-2007 10:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks...for the help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For Action: INsert, Select, Update...
Statement: XYZ or the request
table: Table name..
regards
Hemant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.