Database Writer and Column Names

KNIME Analytics Platform
1

Hi guys,

I'm trying to migrate one of my workflows from 2.10.4 to 2.11.3 and I have som troubles with DB Writer nodes.

On 2.10 column names called for example "Note"  were inserted/appended in a Oracle Table having "NOTE" as column name.

On 2.11.3 instead they are stored as "Note"...so my DB Reader nodes fail since the queries were written with different column names. 

Is there a way to force the DB Writer nodes to be case insensitive with column names?

 

Thanks.

Angelo.

2

Hello Angelo,

I'm sorry to hear that the column name quoting causes you these problems. We introduced it to prevent problems with column names that contain spaces and key words. Unfortunately it is not possible to disable the column name quoting in the DB Writer. As a workaorund for Oracle you could use the Case Converter node before using the DB Reader node and convert all column names to upper case.

Bye

Tobias