tDBRow - PreparedStatement

Anonymous — Sat, 16 Nov 2024 04:01:08 GMT

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 ?

Re: tDBRow - PreparedStatement

Anonymous — Tue, 03 Dec 2019 08:40:14 GMT

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

topic Re: tDBRow - PreparedStatement in Data Quality

tDBRow - PreparedStatement

Re: tDBRow - PreparedStatement