Unsupported Data Type Mapping
When you try to create a cache group, you may receive the following error:
5115: Unsupported type mapping for column name
For example, table tab on the Oracle database can be described as follows:
COL1 NUMBER(38) NOT NULL COL2 NUMBER(38)
Try to create the cache group as follows:
CREATE CACHE GROUP cg FROM tab(col1 CHAR(10) NOT NULL PRIMARY KEY);
Error 5119 is displayed and the cache group is not created because the statement attempts to map a column of NUMBER
data type to a column of CHAR
data type.
See Mappings Between Oracle Database and TimesTen Data Types in the Oracle TimesTen In-Memory Database Cache Guide.