A framework for defining database-specific SQL functions that are available via the dialect.
| Modifier and Type | Interface and Description |
|---|---|
| public interface | SQLFunction
Provides support routines for the HQL functions as used in the various SQL Dialects Provides an interface for supporting various HQL functions that are translated to SQL. |
| Modifier and Type | Class and Description |
|---|---|
| public abstract class | AbstractAnsiTrimEmulationFunction
A |
| public class | AnsiTrimEmulationFunction
A |
| public class | AnsiTrimFunction
Defines support for rendering according to ANSI SQL TRIM function specification. |
| public class | AvgWithArgumentCastFunction
Some databases strictly return the type of the aggregation value for AVG which is problematic in the case of averaging integers because the decimals will be dropped. |
| public class | CastFunction
ANSI-SQL style |
| public class | CharIndexFunction
Emulation of locate() on Sybase |
| public class | ConditionalParenthesisFunction
Essentially the same as |
| public class | ConvertFunction
A Caché definition of a convert function. |
| public class | DB2SubstringFunction
When "substring" function is used for DB2, this implementation of |
| public class | DerbyConcatFunction
A specialized concat() function definition in which:
|
| public class | NoArgSQLFunction
A function which takes no arguments |
| public class | NvlFunction
Emulation of coalesce() on Oracle, using multiple nvl() calls |
| public class | PositionSubstringFunction
Emulation of locate() on PostgreSQL |
| public class | SQLFunctionRegistry
Defines a registry for SQLFunction instances |
| public class | SQLFunctionTemplate
Represents HQL functions that can have different representations in different SQL dialects where that difference can be handled via a template/pattern. |
| public class | StandardAnsiSqlAggregationFunctions
Centralized definition of standard ANSI SQL aggregation functions |
| public class | StandardJDBCEscapeFunction
Analogous to |
| public class | StandardSQLFunction
Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL. |
| public class | StaticPrecisionFspTimestampFunction
A function that returns a |
| public class | TemplateRenderer
Delegate for handling function "templates". |
| public abstract class | TrimFunctionTemplate
Defines the basic template support for TRIM functions |
| public class | VarArgsSQLFunction
Support for slightly more general templating than |