JDBC Lookup error

Hi Expert

I am using the JDBC lookup in my scenario , In my table 3 columns -BusinessUnitEntityKey,SKUIdentifier,RnSKUEntityKey, I want to pick the data based on BusinessUnitEntityKey,

Like:SELECT "SKUIdentifier", "RnSKUEntityKey" FROM "SAP_RNA_SKUS" WHERE BusinessUnitEntityKey= "9011"," 101"

once i run my lookup is is showing error : Cause Exception: 'Error processing request in sax parser: Error when executing statement for table/stored proc. 'table' (structure 'statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '='.'.

it is not picking multiple recoreds at a time .

please help me for this issue .

Regards

pankaj Singh



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2016 at 02:50 AM

    Hi Pankaj,

    AFAIK - you do not need double quote ("") in table and column name in select query. change your query as

    SELECT SKUIdentifier, RnSKUEntityKey FROM SAP_RNA_SKUS WHERE BusinessUnitEntityKey= "9011"," 101"

    and refer the below link

    http://www.w3schools.com/sql/sql_select.asp

    regards,

    Harish

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content