Skip to Content
avatar image
Former Member

Place holder issue

Hi All,

I am using JDBC at reciever side. Using SQL_QUERY I am direclty writing the query to fetch the data from database. But issue is that the place holder values are not been replaced by values at runtime. When I check the communication channel monitoring the place holder value is not been replaced .

SELECT ID from PLAN where ID = $ID$

Above is the query which I am getting from the communication channel monitoring. I am connecting to Orcale database.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 10, 2009 at 11:20 AM

    Have you defined <key> element in the structure? The <Key> should contain list of elements with place holders.

    Refer documentation for JDBC receiver formats-

    http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

    I am using JDBC at reciever side. Using SQL_QUERY I am direclty writing the query to fetch the data from database
    SELECT ID from PLAN where ID = $ID$

    Why did you used SELECT stament with JDBC receiver adap? Is it a synchronous interface and you are looking for responce?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Cna you post the JDBC receiver structure that you have created alongwith the actual XML that is generated in SXMB_MONI....after you remove the company/ client references.

      I hope you are using action as SQL_QUERY

      Regards,

      Abhishek.