Prepared statement with null values in a tOracleRow

Anonymous — Thu, 12 Jul 2018 23:03:07 GMT

I was tOracleRow to execute a SQL update in a prepared statement and I found that the entire job will hang after a small number of rows if there's a null value for any of the columns. There's no output, even if you pass the rows through a tLogRow first. You do get output like this after you kill the job:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
[ERROR]: talend_proj.orbcadtimingdwconsumer_0_1.OrbCadTimingDwConsumer - tOracleRow_1 - null
[ERROR]: talend_proj.orbcadtimingdwconsumer_0_1.OrbCadTimingDwConsumer - tOracleRow_1 - null
[ERROR]: talend_proj.orbcadtimingdwconsumer_0_1.OrbCadTimingDwConsumer - tOracleRow_1 - null
(repeated a bunch more times)

I've resolved this by filtering out the null values and sending them off to a different tOracleRow with the null column omitted, but this is only reasonable if you have a single column that can be null.

Also, even if it is expected that tOracleRow should not bind null parameters to a prepared statement, it should fail more gracefully and explicitly. The current behavior cost me several hours of head-scratching.

Re: Prepared statement with null values in a tOracleRow

Anonymous — Mon, 16 Jul 2018 08:50:55 GMT

Hello,

Have you already tried to mark your input schema as "nullable" in your schema setting?

Best regards

Sabrina

Re: Prepared statement with null values in a tOracleRow

Anonymous — Mon, 16 Jul 2018 17:04:06 GMT

Yep:

topic Re: Prepared statement with null values in a tOracleRow in Talend Studio

Prepared statement with null values in a tOracleRow

Re: Prepared statement with null values in a tOracleRow

Re: Prepared statement with null values in a tOracleRow