Hello,
I haven’t found any problem on MySql database. Isn’t the problem in the metadata? Length and scale can be specified for decimal field only and size shouldn’t be specified fro delimited metadata.
Hi,
I thing that problem is in jdbc oracle driver: after calling method getBytes or getBlob can’t be called other type call method. I’ve found workaround to solve your problem: change field’s order in metadata and in sql queries - that means:
- long type in Oracle: Character data of variable length (A bigger version the VARCHAR2 datatype)
and sqlQuery in input table:
select c2, c1 from t1
sqlQuery in output table
insert into (c2, c1) values (?,?)