topic Re: DynamicUtils - getInsertIntoStmtValuesList(Dynamic column, String database, StringBuilder list) method in Talend Studio

DynamicUtils - getInsertIntoStmtValuesList(Dynamic column, String database, StringBuilder list) method

David_Beaty — Sat, 16 Nov 2024 05:34:19 GMT

Hi,

Looking at this method call that gets used when constructing the SQL INSERT statements when writing data from a dynamic schema to a database, I think it's missing a case to handle null numeric types.

It already has 2 cases for handling DATE and TIME entries, but could do with one or more to cater for numeric values.

This would stop the problem where a null integer column in a dynamic schema is getting changed to a 0 (zero).

Talend Studio 7.1.1.20181026_1147

Re: DynamicUtils - getInsertIntoStmtValuesList(Dynamic column, String database, StringBuilder list) method

Anonymous — Tue, 18 Jun 2019 10:58:20 GMT

Thanks for raising this @dsoulalioux. Would you mind raising issues like this here: https://jira.talendforge.org. Every issue raised in Jira will be assessed and worked on if found to be required, whereas an issue raised here can easily be missed by R&D.

Re: DynamicUtils - getInsertIntoStmtValuesList(Dynamic column, String database, StringBuilder list) method

David_Beaty — Tue, 18 Jun 2019 11:12:14 GMT

Hi,

Thanks @rhall raised a Jira for that issue

https://jira.talendforge.org/browse/TDI-42528