Example: Mapping VARCHAR and TIMESTAMP literals

Your database uses the N-syntax for Unicode string literals. Also, your JDBC driver does not support the ODBC escape syntax for timestamp literals. As in the FunctionMapping element, $R represents the return data type of the expression:

<LiteralMapper>

  <LiteralMappings>

    <LiteralMapping DataTypeName="VARCHAR">

      <Template>N$V</Template>

    </LiteralMapping>

    <LiteralMapping DataTypeName="TIMESTAMP">

      <Template>CAST ($V AS $R)</Template>

    </LiteralMapping>

  </LiteralMappings>

</LiteralMapper>

Copyright Actuate Corporation 2012