Examples of org.hibernate.dialect.function.AvgWithArgumentCastFunction

org.hibernate.dialect.function.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. The usual workaround is to cast the integer argument as some form of double/decimal. @author Steve Ebersole

      registerColumnType( Types.BLOB, "blob" );
      registerColumnType( Types.CLOB, "clob" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

      registerColumnType( Types.BLOB, "blob($l)" );
      registerColumnType( Types.CLOB, "clob($l)" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

      registerColumnType( Types.BLOB, "blob($l)" );
      registerColumnType( Types.CLOB, "clob($l)" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

    registerColumnType( Types.VARBINARY, "binary($l)" );
    registerColumnType( Types.BLOB, "blob" );
    registerColumnType( Types.CLOB, "clob" );


    // Aggregations ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // select topic, syntax from information_schema.help
    // where section like 'Function%' order by section, topic
    //
    // see also ->  http://www.h2database.com/html/functions.html

View Full Code Here

      registerColumnType( Types.BLOB, "blob($l)" );
      registerColumnType( Types.CLOB, "clob($l)" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

    registerColumnType( Types.VARBINARY, "binary($l)" );
    registerColumnType( Types.BLOB, "blob" );
    registerColumnType( Types.CLOB, "clob" );


    // Aggregations ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // select topic, syntax from information_schema.help
    // where section like 'Function%' order by section, topic
    //
    // see also ->  http://www.h2database.com/html/functions.html

View Full Code Here

    registerColumnType( Types.VARBINARY, "binary($l)" );
    registerColumnType( Types.BLOB, "blob" );
    registerColumnType( Types.CLOB, "clob" );


    // Aggregations ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // select topic, syntax from information_schema.help
    // where section like 'Function%' order by section, topic
    //
    // see also ->  http://www.h2database.com/html/functions.html

View Full Code Here

    registerColumnType( Types.BLOB, "longvarbinary" );
    registerColumnType( Types.CLOB, "longvarchar" );
    registerColumnType( Types.LONGVARBINARY, "longvarbinary" );
    registerColumnType( Types.LONGVARCHAR, "longvarchar" );


    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    registerFunction( "ascii", new StandardSQLFunction( "ascii", Hibernate.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", Hibernate.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );
    registerFunction( "upper", new StandardSQLFunction( "upper" ) );

View Full Code Here

    else {
      registerColumnType( Types.BLOB, "blob" );
      registerColumnType( Types.CLOB, "clob" );
    }


    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    registerFunction( "ascii", new StandardSQLFunction( "ascii", Hibernate.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", Hibernate.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );
    registerFunction( "upper", new StandardSQLFunction( "upper" ) );

View Full Code Here

      registerColumnType( Types.BLOB, "blob($l)" );
      registerColumnType( Types.CLOB, "clob($l)" );
    }


    // aggregate functions
    registerFunction( "avg", new AvgWithArgumentCastFunction( "double" ) );


    // string functions
    registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) );
    registerFunction( "lower", new StandardSQLFunction( "lower" ) );

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.hibernate.dialect.function.AvgWithArgumentCastFunction

org.hibernate.dialect.DB2Dialect

org.hibernate.dialect.H2Dialect

org.hibernate.dialect.HSQLDialect

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.