Package org.hibernate.dialect.function

A framework for defining database-specific SQL functions that are available via the dialect.

See: Description

Interface Summary

Interface	Description
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.

Class Summary

Class	Description
AbstractAnsiTrimEmulationFunction	A SQLFunction providing support for implementing TRIM functionality (as defined by both the ANSI SQL and JPA specs) in cases where the dialect may not support the full trim function itself.
AnsiTrimEmulationFunction	A SQLFunction implementation that emulates the ANSI SQL trim function on dialects which do not support the full definition.
AnsiTrimFunction	Defines support for rendering according to ANSI SQL TRIM function specification.
AvgWithArgumentCastFunction	Some databases strictly return the type of the of the aggregation value for AVG which is problematic in the case of averaging integers because the decimals will be dropped.
CastFunction	ANSI-SQL style cast(foo as type) where the type is a Hibernate type
CharIndexFunction	Emulation of locate() on Sybase
ConditionalParenthesisFunction	Essentially the same as StandardSQLFunction, except that here the parentheses are not included when no arguments are given.
ConvertFunction	A Caché defintion of a convert function.
DerbyConcatFunction	A specialized concat() function definition in which: we translate to use the concat operator ('||') wrap dynamic parameters in CASTs to VARCHAR This last spec is to deal with a limitation on DB2 and variants (e.g.
NoArgSQLFunction	A function which takes no arguments
NvlFunction	Emulation of coalesce() on Oracle, using multiple nvl() calls
PositionSubstringFunction	Emulation of locate() on PostgreSQL
SQLFunctionRegistry	Defines a registry for SQLFunction instances
SQLFunctionTemplate	Represents HQL functions that can have different representations in different SQL dialects where that difference can be handled via a template/pattern.
StandardAnsiSqlAggregationFunctions	Centralized definition of standard ANSI SQL aggregation functions
StandardAnsiSqlAggregationFunctions.AvgFunction	Definition of a standard ANSI SQL compliant AVG function
StandardAnsiSqlAggregationFunctions.CountFunction	Definition of a standard ANSI SQL compliant COUNT function
StandardAnsiSqlAggregationFunctions.MaxFunction	Definition of a standard ANSI SQL compliant MAX function
StandardAnsiSqlAggregationFunctions.MinFunction	Definition of a standard ANSI SQL compliant MIN function
StandardAnsiSqlAggregationFunctions.SumFunction	Definition of a standard ANSI SQL compliant SUM function
StandardJDBCEscapeFunction	Analogous to StandardSQLFunction except that standard JDBC escape sequences (i.e.
StandardSQLFunction	Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.
StaticPrecisionFspTimestampFunction	A function that returns a StandardBasicTypes.TIMESTAMP with static fractional seconds precision (fsp).
TemplateRenderer	Delegate for handling function "templates".
TrimFunctionTemplate	Defines the basic template support for TRIM functions
TrimFunctionTemplate.Options
TrimFunctionTemplate.Specification
VarArgsSQLFunction	Support for slightly more general templating than StandardSQLFunction, with an unlimited number of arguments.

Package org.hibernate.dialect.function Description

A framework for defining database-specific SQL functions that are available via the dialect.