cancel
Showing results for 
Search instead for 
Did you mean: 

DB Look Ups using JAVA Mapping

rajasekhar_reddy14
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi,

can you explain How to implement your approch ...

Thank for your replay.

Regards,

Raj

Former Member
0 Kudos

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...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5474f19e-0701-0010-4eaa-97c4f78d...

(3rd Scenario in the above pdf)

Also refer

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards

Answers (1)

Answers (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

solved