Examples of SQLFunctionTemplate

org.hibernate.dialect.function.SQLFunctionTemplate

Represents HQL functions that can have different representations in different SQL dialects. E.g. in HQL we can define function concat(?1, ?2) to concatenate two strings p1 and p2. Target SQL function will be dialect-specific, e.g. (?1 || ?2) for Oracle, concat(?1, ?2) for MySql, (?1 + ?2) for MS SQL. Each dialect will define a template as a string (exactly like above) marking function parameters with '?' followed by parameter's index (first index is 1). @author Alexey Loubyansky @version $Revision: 6608 $


    registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(","||",")" ) );


    registerFunction( "locate", new PositionSubstringFunction() );


    registerFunction( "str", new SQLFunctionTemplate(Hibernate.STRING, "cast(?1 as varchar)") );


    getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE);
  }

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of SQLFunctionTemplate

Examples of org.hibernate.dialect.function.SQLFunctionTemplate