Show Table of Contents
4.3. SQL Translation Extension
The JDBCExcecutionFactory provides several methods to modify the command and the string form of the resulting syntax before it is sent to the JDBC driver, including:
- Change basic SQL syntax options. See the useXXX methods, e.g. useSelectLimit returns true for SQLServer to indicate that limits are applied in the SELECT clause.
- Register one or more FunctionModifiers that define how a scalar function is to be modified or transformed.
- Modify a LanguageObject (see the
translate,translateXXX, andFunctionModifier.translatemethods). Modify the passed in object and return null to indicate that the standard syntax output will be used. - Change the way SQL strings are formed for a LanguageObject (see the
translate,translateXXX, andFunctionModifier.translatemethods). This returns a list of parts which can contain strings and LanguageObjects. These are appended to the SQL string in order. If the incoming LanguageObject appears in the returned list it is not translated again.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.