Skip to Content
author's profile photo Former Member
Former Member

jdbc adapter in reciever side

Hi

I have configured reciever channel to jdbc adapter.I have queried database by Select col_nam from table wher value=...

Please can you tell me the location where i will get the output resulset.

Thanking you in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 03:07 PM

    Hi Piyush,

    To get the response back from JDBC receiver you need to configure your interface with the response structure.

    Refer this weblog for configuring JDBC receiver response.

    /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

    Refer the SAP documention below for response structure format.

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

    A statement with the action SELECT must have exactly one <access>element. The number of <key> elements with arbitrary names is not restricted.

    The corresponding SQL statement for StatementName4in the example above is as follows:

    “

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

    “

    If there is no <key> element, or if there is a <key> element but it is empty, then no condition is specified and the entire table is to be selected. This may not be permitted by the configuration of the JDBC adapter for security reasons and will therefore result in an error during message processing and an appropriate error message.

    The response document contains the result of the action in XML format as follows:

    “

    <row>

    <column1>value11</column1>

    <column2>value12</column2>

    ...

    </row>

    ...

    <row>

    <column1>valueN1</column1>

    <column2>valueN2</column2>

    ...

    </row>

    “

    hope this helps..

    Regards

    Anand

    Message was edited by: Anand Torgal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 04:17 AM

    Hi Piyush,

    For getting the resultset you need another msg type and data type with the same name (eg:<i>something</i>_<b>response</b>.Here you specify the column names which needs to be fetched.

    And dont forget to map this response to anotehr msg type(eg:http response)as this is a case f a sync scenario.

    Regards,

    Priyanka

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi priyanka

      thanks for your suggestion.

      In current scenario,is same as 3 steps described by you.

      but that one is with bpm.

      Bpm is not used,

      here ,I am using sender as a asynchonous outbound interface .

      and reciever as a synchronous inbound interface.

      I want enquire that can i specify target diretory for a response from reciever?

      If yes,then please let me know how?

      for synchonous reciever for any adapter, I have yo use bpm or .......

      Please guide me.

      Thanks in advance.

      Regards

      piyush

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.