English

FAQ: Why does the SimpledataLoader and the ObjectLoader map RDBMS integer fields to doubles?

Question

Why does the SimpledataLoader and the ObjectLoader map RDBMS integer fields to doubles?

Answer

When you export long integers from Oracle they are mapped to a double to avoid overflow. Oracle does not have a true long integer type, using a number(10), which can contain numbers larger than will fit into a long. This also is a problem with short integers, which map to a long integer on export.

Currently the ObjectLoader UI does not allow the mapping of larger fields to smaller fields. This could be changed, but at the risk of having some imports failing in the middle of the load when a field is too wide.

The workaround is to use double rather than long integer when you plan on constantly importing and exporting data into the same template.