Problems in Insert or update in tabular format

[vinayak115]

We are using the dbfit testing with oracle DB and some of the tables have columns that are in lower case and it was done on purpose. When we use the dbfit insert in tabular format, we provide column names in smaller case like "id". DBFIT converts that field into upper case => ID, and when the test runs it trying to find ID column which does not exist.

Is there a plan to make DBFIT with Oracle compatible for lower case columns?

[vinayak115]

It is about the fields having double quotes in their name. "id"

[kingpinsf]

Just to be clear...
The issue here is that, even when a tabular INSERT specifies the column name with double quotes (e.g. "id" or "address"), DBFit will strip off the quotes when it generates the INSERT statement (e.g. insert into mytable (id, address) values (?,?)).

Oracle will not recognize the lowercase column names without the quotes, expecting to find columns with uppercase names - (e.g. ORA-00904 "ID": invalid identifier).

If DBFit respected the quotes in the tabular INSERT column name and included them in the generated INSERT statement, then this could work.

Can that be fixed?