tDBRow - PreparedStatement

[Anonymous]

Hi !

I need to extract data from a JDBC database using a SQL query. When I use a tDBInput component as below it works well :

It means that my connection and my query work and are correct.

Now I want to add a bound parameter to my query, so I must replace tDBInput with tDBRow to access the PreparedStatement section where I can fill in my parameter. My new job is then :

But it's not working anymore, I'm getting null values for all columns as result.

Here is my query :

And here my PreparedStatement section :

One last thing : when I run the job using tDBRow with the parameter value directly in my query as below, I get null results as well... :

Can Someone please help me ?

[Anonymous]

Hello,

The tXXXRow component is usually used to any type of sql statement excepts select statement,  we use txxxInput component to execute a select statement, if you use use tXXXRow to execute a select statement, it returns a record set, and you are required to use a tParseRecordSet component after tXXXRow to parse the record sets.

Best regards

Sabrina