action = SELECT in JDBC Receiver

[Former Member]

Hi Friends,

Can anyone please clarify my doubt?

Does action = SELECT will return the table fields according to the specified condition? If so , how can I see the result , I mean how can I see the fields that are retrieved by action=SELECT statement?

What should be the Message Interface?

Regards,

Raju...

[former_member187339 · Accepted solution]

Hi,

>>Does action = SELECT will return the table fields according to the specified condition?

Yes.

>>how can I see the result , I mean how can I see the fields that are retrieved by action=SELECT statement?

The response Message Type should have SenderMT<b>_Response</b> as name. For more info refer...

<u>http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm</u>

<i>action=SELECT

Statements with this action cause existing table values to be selected. Therefore, the statement corresponds to an SQL SELECT statement.

The <access> block contains the column names to be selected, a <key>element contains the columns whose values must be identical with the specified value to get the new column values. The name of the <key> element is arbitrary. Column values within a <key> element are combined with a logical AND; different <key>elements are combined with a logical OR.

...

<b>The response document contains the result of the action in XML format as follows:</b>

<row>

<column1>value11</column1>

<column2>value12</column2>

...

</row>

...

<row>

<column1>valueN1</column1>

<column2>valueN2</column2>

...

</row></i>

>>What should be the Message Interface?

Should be SYNC, INBOUND

Regards

Suraj

Message was edited by: S.R.Suraj

Message was edited by: S.R.Suraj

[Former Member · Accepted solution]

I created three Message types

1> VendorSource

2> VendorTarget

3> VendorSource_Response

and the structure of response is

<b>>VendorSource_Response

>>row

VendorNumber

VendorName</b>

And I have kept the two interfaces as synchronous

i.e., Outbound/Synchronous and Inbound/Synchronous.

In configuration I have given Sender Agreement, Receiver Determination i.e., MSAccess, Interface determination with VendorSource_MI as source Interface and VendorTarget_MI as target Interface with two mapping programs for request and response, and the Receiver Agreement.

Now do I need to do anything more. Since it is synchronous, will the response come directly to XI without any further configuration?

Regards,

Raju...

[Former Member · Accepted solution]

Hi narayana,

No the response of JBDC select stmt. will directly come to XI , no further configuration is required.

If u r message type is not matching with JDBC response structure then go to sxmb_moni there u can see JDBC response for u r select stmt. then create the same message type in u r IR to receive JDBC response .

Regards,

Keith.

[Former Member · Accepted solution]

HI

Thanks for the reply,

But still I could not see the response.

I could only see the source message from file and target message to MSAccess in SXMB_MONI but I could not see the response from MSAccess. What is the problem?

Regards,

Raju...

[bhavesh_kantilal · Accepted solution]

hi,

check the status of your JDBC adapter in RWB. Does it have any error?

Regards,

bhavesh

[Former Member · Accepted solution]

HI Narayana,

Just check whether u r select stmt. is getting executed correctly or not , verify it from message monitoring and also check u r adapter monitoring for status of JDBC adpter .

Regards,

Keith.

[Former Member · Accepted solution]

HI

My message monitoring says

<b>Database request processed successfully</b>

<b>The message was successfully delivered to the application using connection AFW</b>

In my Adapter Monitoring the communication channel says

<b>processing finished successfully</b>

But I cant see any message regarding the response in SXMB_MONI.

And also there is only one message in sxmb_moni.i.e., from File to MSAccess. But there is no other message seen.

[former_member187339 · Accepted solution]

Hi,

In MSAccess the SELECT query is like

SELECT <i>tablename.fieldname</i> from <i>tablename</i>...

Try this..

Regards

Suraj

[Former Member · Accepted solution]

Hi Suraj,

How can I specify the command as TableName.FieldName,

bcos I think the only way to do this is to change the target datatype as

>VendorTarget_DT

>>Select

>>>VendorInfo

action

table

>>>>access

VendorNumber

VendorInfo.VendorName

VendorInfo.VendorAddress

>>>>key

VendorNumber

But the name of datatype should not be a special character i.e., '.'

it gives an error.

So, How can I specify the query as given by you?

Regards,

Raju...

[bhavesh_kantilal · Accepted solution]

Hi,

you also execture SELECT using <b>ACTION = SQL_QUERY.</b>

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

Regards,

Bhavesh

[former_member187339 · Accepted solution]

Hi,

Try this:

<root>

--<stmt>

-

---

<VendorInfo action="SQL_QUERY">

-

---

<access> SELECT VendorNumber = ’$VENDORNUMBER$’ VendorInfo.VendorName VendorInfo.VendorAddress

</access>

-

---

<key>

-

---

<VENDORNUMBER>VendorNumber</VENDORNUMBER>

-

---

</key>

-

---

</VendorInfo>

--</stmt>

Regards

Suraj

[Former Member · Accepted solution]

Hi

the same problem still exists.

I have used the SQL_QUERY as you said...but still I can see only one message in SXMB_MONI, and the response could not be seen. Adapter Monitoring and Component Monitoring show that the database request processed successfully.

Why the response is not visible ? Am I missing any configuration still???

Regards,

Raju...