Examples of VarArgsSQLFunction

org.hibernate.dialect.function.VarArgsSQLFunction
Support for slightly more general templating than {@link StandardSQLFunction}, with an unlimited number of arguments. @author Gavin King

Examples of org.hibernate.dialect.function.VarArgsSQLFunction


    registerFunction( "rowid", new NoArgSQLFunction("rowid", Hibernate.LONG, false) );
    registerFunction( "rownum", new NoArgSQLFunction("rownum", Hibernate.LONG, false) );


    // Multi-param string dialect functions...
    registerFunction( "concat", new VarArgsSQLFunction(Hibernate.STRING, "", "||", "") );
    registerFunction( "instr", new StandardSQLFunction("instr", Hibernate.INTEGER) );
    registerFunction( "instrb", new StandardSQLFunction("instrb", Hibernate.INTEGER) );
    registerFunction( "lpad", new StandardSQLFunction("lpad", Hibernate.STRING) );
    registerFunction( "replace", new StandardSQLFunction("replace", Hibernate.STRING) );
    registerFunction( "rpad", new StandardSQLFunction("rpad", Hibernate.STRING) );

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerFunction( "to_char", new StandardSQLFunction("to_char", Hibernate.STRING) );
    registerFunction( "to_date", new StandardSQLFunction("to_date", Hibernate.DATE) );
    registerFunction( "to_timestamp", new StandardSQLFunction("to_timestamp", Hibernate.TIMESTAMP) );
    registerFunction( "to_number", new StandardSQLFunction("to_number", Hibernate.BIG_DECIMAL) );


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


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


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

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerFunction( "to_char", new StandardSQLFunction("to_char", StandardBasicTypes.STRING) );
    registerFunction( "to_date", new StandardSQLFunction("to_date", StandardBasicTypes.DATE) );
    registerFunction( "to_timestamp", new StandardSQLFunction("to_timestamp", StandardBasicTypes.TIMESTAMP) );
    registerFunction( "to_number", new StandardSQLFunction("to_number", StandardBasicTypes.BIG_DECIMAL) );


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


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


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

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

   */
  public Ingres9Dialect() {
    super();
    registerDateTimeFunctions();
    registerDateTimeColumnTypes();
    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "(", "||", ")" ) );
  }

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerFunction( "bit_not", new StandardSQLFunction( "bit_not" ) );
    registerFunction( "bit_or", new StandardSQLFunction( "bit_or" ) );
    registerFunction( "bit_xor", new StandardSQLFunction( "bit_xor" ) );
    registerFunction( "character_length", new StandardSQLFunction( "character_length", StandardBasicTypes.LONG ) );
    registerFunction( "charextract", new StandardSQLFunction( "charextract", StandardBasicTypes.STRING ) );
    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "(", "+", ")" ) );
    registerFunction( "cos", new StandardSQLFunction( "cos", StandardBasicTypes.DOUBLE ) );
    registerFunction( "current_user", new NoArgSQLFunction( "current_user", StandardBasicTypes.STRING, false ) );
    registerFunction( "current_time", new NoArgSQLFunction( "date('now')", StandardBasicTypes.TIMESTAMP, false ) );
    registerFunction( "current_timestamp", new NoArgSQLFunction( "date('now')", StandardBasicTypes.TIMESTAMP, false ) );
    registerFunction( "current_date", new NoArgSQLFunction( "date('now')", StandardBasicTypes.TIMESTAMP, false ) );

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerFunction( "translate", new StandardSQLFunction( "translate", StandardBasicTypes.STRING ) );


    registerFunction( "add_months", new StandardSQLFunction( "add_months", StandardBasicTypes.DATE ) );
    registerFunction( "user", new NoArgSQLFunction( "user", StandardBasicTypes.STRING, false ) );
    registerFunction( "rownum", new NoArgSQLFunction( "rownum", StandardBasicTypes.LONG, false ) );
    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "", "||", "" ) );


    registerKeyword( "TYPE" );
    registerKeyword( "YEAR" );
    registerKeyword( "MONTH" );
    registerKeyword( "ALIAS" );

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.STRING ) );
    registerFunction( "index", new StandardSQLFunction( "index", StandardBasicTypes.INTEGER ) );


    registerFunction( "value", new StandardSQLFunction( "value" ) );


    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "(", "||", ")" ) );
    registerFunction( "substring", new StandardSQLFunction( "substr", StandardBasicTypes.STRING ) );
    registerFunction( "locate", new StandardSQLFunction( "index", StandardBasicTypes.INTEGER ) );
    registerFunction( "coalesce", new StandardSQLFunction( "value" ) );


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

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

    registerColumnType( Types.VARBINARY, "byte" );
    registerColumnType( Types.VARCHAR, "varchar($l)" );
    registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
    registerColumnType( Types.VARCHAR, 32739, "lvarchar($l)" );


    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "(", "||", ")" ) );
    
    uniqueDelegate = new InformixUniqueDelegate( this );
  }

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction


    registerFunction( "substring", new StandardSQLFunction( "substr", StandardBasicTypes.STRING ) );
    registerFunction( "bit_length", new SQLFunctionTemplate( StandardBasicTypes.INTEGER, "length(?1)*8" ) );
    registerFunction( "trim", new SQLFunctionTemplate( StandardBasicTypes.STRING, "trim(?1 ?2 ?3 ?4)" ) );


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


    registerFunction( "str", new SQLFunctionTemplate( StandardBasicTypes.STRING, "rtrim(char(?1))" ) );


    registerKeyword( "current" );
    registerKeyword( "date" );

View Full Code Here

Examples of org.hibernate.dialect.function.VarArgsSQLFunction


    registerFunction( "rowid", new NoArgSQLFunction( "rowid", StandardBasicTypes.LONG, false ) );
    registerFunction( "rownum", new NoArgSQLFunction( "rownum", StandardBasicTypes.LONG, false ) );


    // Multi-param string dialect functions...
    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "", "||", "" ) );
    registerFunction( "instr", new StandardSQLFunction( "instr", StandardBasicTypes.INTEGER ) );
    registerFunction( "instrb", new StandardSQLFunction( "instrb", StandardBasicTypes.INTEGER ) );
    registerFunction( "lpad", new StandardSQLFunction( "lpad", StandardBasicTypes.STRING ) );
    registerFunction( "replace", new StandardSQLFunction( "replace", StandardBasicTypes.STRING ) );
    registerFunction( "rpad", new StandardSQLFunction( "rpad", StandardBasicTypes.STRING ) );

View Full Code Here

0 1 2 3 4 5

TOP

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.