on 09-22-2016 7:47 AM
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 -
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Experts,
Figured out it was a parameter that needs to be added in the connection string.. else it will always poitn to the default schema of the database...
Connection Parameters - SAP HANA Client Interface Programming Reference - SAP Library
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.