JDBC Receive --- action = "SELECT"

[Former Member]

Hi Friends,

Iam trying a scenario where Iam using JDBC Receiver with action = SELECT.

To be clear I'll explain the scenario.

Source_File>XI>MSAccess>XI>Target_File.

I mean, I want to send a file to MSAccess and retrieve the values from table using action = SELECT and put that in a new File.

<b>I></b>

1)My Source DataType (Emp_out_DT) is (This from File to XI)

<b>>Emp_out_DT

>>Emp_No

>>Emp_Name</b>

2)Target Datatype (Emp_in_DT) is (This is from XI to MSAccess)

<b>>Emp_in_DT

>>Select

>>>EmpInfo

action

table

>>>>access

Emp_No

Emp_Name</b>

3)Response DataType (Emp_in_Res_DT) (This is from MSAccess to XI)

<b>>Emp_in_Res_DT

>>row

Emp_No

Emp_Name</b>

<b>II></b>

I have created three Message Types for the three DataTypes.

<b>III></b>

I created two Message Interfaces as

1)Outbound , Synchronous (Emp_out_MI) with

output Message ---> Emp_out_MT

input Message ---> Emp_out_MT

These two are same...

2)Inbound , Synchronous (Emp_in_MI) with

input Message ---> Emp_in_MT

output Message ---> Emp_in_Res_MT

<b>IV></b>

I have done the mapping between

1)Emp_out_MT and Emp_in_MT

2)Emp_in_Res_MT and Emp_out_MT

<b>V></b>

Only one Interface Mapping with

1)Request

Source Interface ---> Emp_out_MI

Target Interface ---> Emp_in_MI

Mapping ---> Emp_out_MT_Emp_in_MT

2)Response

Source Interface ---> Emp_out_MI

Target Interface ---> Emp_in_MI

Mapping ---> Emp_in_Res_MT_Emp_out_MT

Since both are synchronous interfaces, even though MI are same for both the MT will change based on Request and Response.

<b>VI></b>

In Configuration I created three Communication Channels

1)File Sender

2)JDBC Receiver

3)File Receiver

Upto JDBC Receiver it is OK. I have created all the Sender Agreement, Receiver Determination and all. But wat to do with the Response that I get from MSAccess. Will I get the Response from MS Access with this Configuration. How and Where can I see the Response. How to create a File with the Response I got???

Regards,

Raju...

[Former Member · Accepted solution]

Hi narayan ,

Just check the following links for proper Meassge type in JDBC format :

<a href="/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes:///people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

also

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm</a>

JDBC adapter will return the details depending on the select statement u will have to map that response to the message type u r using to create the file using ftp adapter.

regards,

keith.

[former_member187339]

Hi,

Few points:

1) Your scenario is same as this one (except that you are using JDBC)

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

2) Response MT from MSAccess should have Emp_in_MT_Response as the name.

3) Since file is asynchronous you have to write your output to separate file.

Regards

Suraj

[Former Member]

HI

Thanks for the Response.

But my question is that does JDBC Receiver with action = "SELECT" will fetch the data from the database according to the access and key values specified? And where and how can I catch this data?

regards,

Raju...