TimesTen Error Messages

TT-05125

Caching of Timestamp column(s) with difference scale: fractional seconds may be truncated


Cause

The scale of the TimesTen TIMESTAMP type is always 6. Mapping of Oracle database TIMESTAMP COLUMNS with a scale other than 6 to a TimesTen TIMESTAMP column may cause silent truncation of the column value at runtime.


Action

Any values for the fraction not specified in full microseconds results in a "Data Truncated" error. Conform to the format, which is YYYY-MM-DD HH:MI:SS [.FFFFFFFFF].


Additional Information

The column may be truncated.