Package org.hibernate.dialect.function
package org.hibernate.dialect.function
A framework for defining database-specific SQL functions that are available via the dialect.
-
ClassDescriptionA
SQLFunctionproviding 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.ASQLFunctionimplementation that emulates the ANSI SQL trim function on dialects which do not support the full definition.Defines support for rendering according to ANSI SQL TRIM function specification.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.ANSI-SQL style cast(foo as type) where the type is a Hibernate typeEmulation of locate() on SybaseClassic AVG sqlfunction that return types as it was done in Hibernate 3.1Classic COUNT sqlfunction that return types as it was done in Hibernate 3.1Classic SUM sqlfunction that return types as it was done in Hibernate 3.1Essentially the same asStandardSQLFunction, except that here the parentheses are not included when no arguments are given.A Caché defintion of a convert function.A specialized concat() function definition in which: we translate to use the concat operator ('||') wrap dynamic parameters in CASTs to VARCHARA function which takes no argumentsEmulation of coalesce() on Oracle, using multiple nvl() callsEmulation of locate() on PostgreSQLProvides 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.Represents HQL functions that can have different representations in different SQL dialects.TODO : javadocDefinition of a standard ANSI SQL compliant AVG functionDefinition of a standard ANSI SQL compliant COUNT functionAnalogous toStandardSQLFunctionexcept that standard JDBC escape sequences (i.e.Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.Delegate for handling function "templates".Defines the basic template support for TRIM functionsSupport for slightly more general templating thanStandardSQLFunction, with an unlimited number of arguments.