Also see common JDBC Translator Information

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