Question

JDBC_02 error

  • 3 February 2023
  • 1 reply
  • 32 views
P
Rank

Hi Team

I am facing some issue like incorrect syntax at ‘=’ while doing jdbc lookup.

I am trying to lookup column a and fetch b,c columns from Table-X.

For some rows, this error comes, But the same rows when executing independently in SQL-server, I am able to fetch

But from SS-its not fetching.

 

Please help me on this.

 

Regards

Priyanka

 

1 reply

Bikram
Rank
Userlevel 5
Badge +1

@Priyanka Mynepally 

 

Kindly try to prepare your query as given below and let me know if it help.

select b,c from X where ABC='${record:value('/a')}'

 

Kindly provide the error details with your sql query .so i can help on it.

 

Thanks & Regards

Bikram_

Reply


Terms & Conditions