Skip to Content

JDBC look up on a custom table in HANA DB

Hello Folks,

I am using jdbc look ups in sap pi , 7.3 AEX

In message mapping , I used the jdbc look up to query data from a table .

I am able to connect to the table , fetch meta data , select the fields in the look up but on executing it throws an error

for the where fields do I need to use a "" or ' or anything else in config of the channel?

ur inputs and ideas pls

ravi -

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Sep 22, 2016 at 08:02 AM

    Hi all,

    I think Ravi could be right with the double quotation marks: Defining JDBC Lookups Graphically - SAP NetWeaver Process Integration - SAP Library

    In the mapping lookup, access an ORDER field that contains a request number. The SQL SELECT statement however contains an ORDER keyword to set the order. To identify the field in the SELECT statement as identifier for a field it must be set in doubled quotation marks ("ORDER" ). Otherwise the statement syntax is incorrect.

    May be is a problem in Hana DB that it has not activated to work with these case, as per below documentation.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 22, 2016 at 07:32 AM
    for the where fields do I need to use a "" or ' or anything else in config of the channel?

    Do you mean key fields ? Try adding single quote for the value which you are passing .

    Can you give sample SQL query which you are getting error.

    Br,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2016 at 07:53 AM

    Hi Ravi,

    For the where field you have to use single quote .

    Can you provide the SQL query for which you are getting error.

    Thanks

    Sagarika

    Add a comment
    10|10000 characters needed characters exceeded

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.