Ask Your Question

JDBC lookup - query parameters

asked 2018-07-20 12:51:23 -0500

lucaz248 gravatar image

updated 2018-07-20 14:51:48 -0500

metadaddy gravatar image

How do I use parameters in a JDBC lookup query?

Something like:

select * from table1 where field1= ${record.value('/field')}

Is it possible?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2018-07-20 14:51:17 -0500

metadaddy gravatar image

That's exactly what you do. In the JDBC Lookup processor, set the SQL Query to something along the lines of

select * from table1 where field1 = ${record.value('/field')}

The record will be populated with the columns from the matching row.

edit flag offensive delete link more


Thx :). I see the link, and surely I am writing something wrong.

lucaz248 gravatar imagelucaz248 ( 2018-07-20 18:07:31 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-20 12:51:23 -0500

Seen: 980 times

Last updated: Jul 20 '18