synchronous Receiver JDBC - Used View instead of DB Table

[Former Member]

Hi All,

I used the database View instead of DB table in receiver adapter. Messages in the SXMB_MONI is successful but I am not see any records in receiver response JDBC message.

Is it any problem to use the view or any thing else?

Thanks in advance,

Naren

[Former Member]

Hi Narendra,

I think this will be useful.

Refer to Configuration of Receiver JDBC adapter on help.sap.com for more information.

>>>><i>SELECT col1,col2,col3 FROM dbTableName WHERE ((col2=’val2old’ AND col4=’val4’) OR (col2=’val2old2’))

<StatementName4>

<dbTableName action=”SELECT”>

<table>realDbTableName</table>

<access>

<col1/>

<col2/>

<col3/>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName4></i>

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/44/79973cc73af456e10000000a114084/frameset.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/44/79973cc73af456e10000000a114084/frameset.htm</a>

Thanks,

Beena

[Former Member]

I want to genertae the where clause like

where empcode = '1' AND ( name = 'ABC' OR name = 'CDF' );

How I can define this structure in receiver JDBC.

Thanks

Regards,

[Former Member]

thanks a lot.

It's working fine. Some problem in database data and query returns 0 rows.

You guys are right that no difference to in table and view to use in select.

One more query:

How I can pass the multiple values in select query

for ex: emp code = '1'

Name = 'ABC'

NAME = 'CDF' etc..

data in database looks like

empcode Name

1 ABC

1 CDF

2 MNG

How I can use the ''compareoperation' for this above example..

Thanks

Narendra

[Former Member]

Hello Narendra!

If there's a succesfull response message in SXMB_MONI, i think your query doesn't return data. Did you check if your query you send with the request returns data?

To make a request against a View is no problem, like VJ mentioned it is handled the same as a table in the database.

Sebastian

[bhavesh_kantilal]

Hi,

What is the status of the receiver JDBC adapter in the Comm Channel Monrioting. That will provide more info.

Regards

Bhavesh

[VijayKonam]

Technically, a table and view are handled by a database in a same for a user. I did not try this out but, using a view should not make any difference.

Could you please elaborate on the scneario, that if the receiver side is a select query used? any the status of the adaptor/message monitoring results?

VJ