Package org.hibernate.dialect.function

Examples of org.hibernate.dialect.function.AvgWithArgumentCastFunction

72
73
74
75
76
77
78
79
80
81
82
    registerColumnType( Types.LONGVARBINARY, "long varchar for bit data" );
    registerColumnType( Types.BINARY, "varchar($l) for bit data" );
    registerColumnType( Types.BINARY, 254, "char($l) for bit data" );
    registerColumnType( Types.BOOLEAN, "smallint" );

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

    registerFunction( "abs", new StandardSQLFunction( "abs" ) );
    registerFunction( "absval", new StandardSQLFunction( "absval" ) );
    registerFunction( "sign", new StandardSQLFunction( "sign", StandardBasicTypes.INTEGER ) );
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    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
120
121
122
123
124
125
126
127
128
129
130
    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
132
133
134
135
136
137
138
139
140
141
142
      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
66
67
68
69
70
71
72
73
74
75
76
    registerColumnType( Types.LONGVARBINARY, "long varchar for bit data" );
    registerColumnType( Types.BINARY, "varchar($l) for bit data" );
    registerColumnType( Types.BINARY, 254, "char($l) for bit data" );
    registerColumnType( Types.BOOLEAN, "smallint" );

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

    registerFunction( "abs", new StandardSQLFunction( "abs" ) );
    registerFunction( "absval", new StandardSQLFunction( "absval" ) );
    registerFunction( "sign", new StandardSQLFunction( "sign", StandardBasicTypes.INTEGER ) );
View Full Code Here
TOP

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

  • org.hibernate.dialect.DB2Dialect
  • org.hibernate.dialect.H2Dialect
  • org.hibernate.dialect.HSQLDialect
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.