Also see common JDBC Translators information.

The JDBC Simple translator, known by the type name jdbc-simple, is the same as the jdbc-ansi-translator, except that it disables support for nearly all pushdown constructs for maximum compatibility.