Ask Your Question

In JDBC Lookup processor, how can I use my previous stage (MySQL Binary Log) field data to write query in JDBC Lookup and write to some destination?

asked 2018-01-24 06:09:35 -0500

updated 2018-01-24 11:11:29 -0500

metadaddy gravatar image

I am using MySQL Binary Log as origin and JDBC Lookup as processor. I want to query data in JDBC Lookup on the basis of my previous stage (MySQL Binary Log) data. But I am not able to use that passed data in my query and write to some destination. Can anyone suggest something?

edit retag flag offensive close merge delete


This seems like a duplicate of - is it basically the same question?

metadaddy gravatar imagemetadaddy ( 2018-01-24 11:10:39 -0500 )edit

What specific problems are you hitting? You should be able to reference fields in the record from the JDBC Lookup.

metadaddy gravatar imagemetadaddy ( 2018-01-24 11:12:07 -0500 )edit

I want to perform some join operation in jdbc lookup based on the changed data ( id ) coming from mysql binary log.

ImPranjalk gravatar imageImPranjalk ( 2018-01-24 11:47:01 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-06-11 18:19:19 -0500

iamontheinet gravatar image


Here's how you can reference record field value set in the stages prior to JDBC Lookup processor. For example, in my case I am looking up records based on record field called pid with this expression ${record:value('/pid')} in the where clause.

image description

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-24 06:09:35 -0500

Seen: 266 times

Last updated: Jun 11