topic Oracle tDBRow select returns NULLs in Talend Studio

Oracle tDBRow select returns NULLs

PhilHibbs — Fri, 15 Nov 2024 22:45:20 GMT

I've got a simple job that connects to an Oracle database with a tDBRow component and does

select sysdate from dual;

It runs and outputs one row, but when I put a tLogRow component in it's blank, and if I put a tJavaRow in and print out input_row.column_1 it prints "null".

Can anyone think why this might be? I picked a working connection from the metadata, I've put in a single column definition to the output and propagated it to the next component.

I'm using the same database connection to run a PL/SQL block in a different job and it's fine.

We're using the free edition v7.3.1.

Re: Oracle tDBRow select returns NULLs

manodwhb — Tue, 12 Jul 2022 00:15:51 GMT

@Phil Hibbs , If possible can you share your job design? basically this component is designed to execute the queries and not return and pass the selected data to the next component . if you want to use select query and pass that query result to next component than the best way is use tDBInputrow .

Thanks,

Manohar

Re: Oracle tDBRow select returns NULLs

PhilHibbs — Tue, 12 Jul 2022 08:01:53 GMT

That will be it, thanks! sorry it's been a long time since I used Talend, and that was on Big Data Edition with Hadoop. Just getting used to the tool again!