on 12-10-2008 6:19 AM
Hi Frnds,
I'm working one B2B Project, my question is,
I have to retrieve Order ,Order Response from one Data Base,
its already stored in DATA BASE as a CLOB Message.
I developed one JAVA Map to retrieve Order And Order Response.
its working fine,
But i made a connection through JAVA Map only,
But as Per SAP its not a good advice to perform Statefull operations through JAVA Mapping.
My Client not accpeting this approach.
what is the next way,
I performed some DB Look up using JDBC Adapter And Visula Admin.
But in this case its not a easy to retrieve the Order And Order Response.
Because in My logic there is 5 SQL Statements there.
Any one can provide Solution.
Thanks ,
Raj
Hi,
It is wise, you shouldnt access database directly from Java mapping.
You can go for synchronous stored procedure... In it you will have to handle your select queries. It's return parameter will be Order and Order.response.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As you said, you have to run 5 sql statements and fetch Order and OrderResponse. Let's say all your inputs for these sql statements are A,B,C,D,E then these will be input parameters for Stored Procedure and out parameters will be Order and OrderResponse. Fetching logic should be in the stored proc.
By this approach you will get Order and OrderResponse in the Stored Proceedure response structure. That structure you can map to your Receiver structure. (if i am not wrong this is your aim)
You can see this sample blog on Stored Procedure scenario...
(3rd Scenario in the above pdf)
Also refer
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
Regards
solved
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 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.