Ask Your Question
1

JDBC lookup - query parameters

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

lucaz248 gravatar image

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

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
0

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

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

Comments

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

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

Question Tools

1 follower

Stats

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

Seen: 61 times

Last updated: Jul 20