DataType child element: Aliases
The database may have other names or aliases for a data type. For example, on SQL Server INT is also called INTEGER. You must define the aliases so that the Integration service can recognize the data type when the database column uses an alias. To define aliases, use the Aliases element. The Aliases element has one child element, Alias. Define each alias using the Alias element.
The following example assumes you have a database that has the following data types: CHAR, VARCHAR, NVARCHAR, SMALLINT, INT, DECIMAL, FLOAT, and DATETIME. The Integration service maps all of these to generic SQL data types except NVARCHAR and FLOAT. For these data types, the Integration service returns an error such as Type is not supported. The Integration service returns an error because the JDBC driver does not provide the generic SQL type for FLOAT or NVARCHAR. You must define a mapping for data types that the JDBC driver cannot map.
Using your database documentation and the descriptions in Table 10-1, you select generic SQL types for NVARCHAR and FLOAT. You also define an alias for FLOAT:
<DataTypeMapper>
  <DataTypes>
    <DataType Name="NVARCHAR" GenericSQLType="VARCHAR" />
    <DataType Name="FLOAT" GenericSQLType="DOUBLE">
      <Aliases>
        <Alias>DOUBLE</Alias>
      </Aliases>
    </DataType>
  </DataTypes>  
</DataTypeMapper>
 
 

Additional Links:

Copyright Actuate Corporation 2012