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>