topic Null values passed to tDBRow prepared statements in Talend Studio

Null values passed to tDBRow prepared statements

GKarg — Fri, 15 Nov 2024 23:44:37 GMT

Hi everyone!

Is there any way that I can use NULL in a tDBRow prepared statement as Int or String parameter value?

Every time I pass a null as a parameter value it throws back null pointer exception.

I use Talend Open Studio for Big Data 7.3.1

Looks like auto generated code is designed just for Date type parameters:

Why is that so?

Regards

Grzegorz

Re: Null values passed to tDBRow prepared statements

Anonymous — Thu, 16 Sep 2021 02:48:51 GMT

Hello,

What does your prepared statement look like?

Have you tried to set all the null values to an empty string "" in a tDBRow prepared statement as String parameter value?

Best regards

Sabrina

Re: Null values passed to tDBRow prepared statements

GKarg — Thu, 16 Sep 2021 11:26:58 GMT

Thanks Sabrina - it worked! I just had to cast these values in the query back to int like so:

INSERT INTO _kafka_fos_raw_log (...)

VALUES (?,?,?,?,?,?,?,?,?,?,?,?::int,?::int,?::int,?::int,?::int,?::int,?::int,?::int,?::int,?::int)

ON CONFLICT ON CONSTRAINT unique_raw_log DO NOTHING;

It's a bit sketchy and I wonder how much it affects performance, but such workaround works fine.

I think the best solution of my problem would be to have the option "on conflict do something" in the postgres tDBInput component because that's why I'm using dbrow instead of dbinput.

Anyway, big thanks for your help!

Best regards

Grzegorz

Re: Null values passed to tDBRow prepared statements

Anonymous — Fri, 17 Sep 2021 02:30:36 GMT

Hello,

Great it works. Indeed, it is a bit sketchy. I will make a discussion with our manager to see if there is any better solution.

It seems the option "on conflict do something" to be a work item/new feature.

Feel free to raise a jira issue on talend bug tracker about it.

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina