Package org.hibernate.dialect.function

Examples of org.hibernate.dialect.function.VarArgsSQLFunction

384
385
386
387
388
389
390
    // xmlforest requires a new kind of function constructor
    registerFunction( "year", new StandardJDBCEscapeFunction( "year", StandardBasicTypes.INTEGER ) );
  }

  protected final void register71Functions() {
    this.registerFunction( "str", new VarArgsSQLFunction( StandardBasicTypes.STRING, "str(", ",", ")" ) );
  }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    registerFunction( "ceiling", new StandardSQLFunction("ceiling") );
    registerFunction( "floor", new StandardSQLFunction("floor") );

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

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

    registerFunction( "length", new StandardSQLFunction( "len", StandardBasicTypes.INTEGER ) );
    registerFunction( "trim", new SQLFunctionTemplate( StandardBasicTypes.STRING, "ltrim(rtrim(?1))") );
    registerFunction( "locate", new CharIndexFunction() );
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
    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
52
53
54
55
56
57
58
59
60
    registerColumnType( Types.VARBINARY, "blob" );
    registerColumnType( Types.NUMERIC, "numeric($p,$s)" );
    registerColumnType( Types.BLOB, "blob" );
    registerColumnType( Types.CLOB, "blob sub_type 1" );
   
    registerFunction( "concat", new VarArgsSQLFunction( StandardBasicTypes.STRING, "(","||",")" ) );

    getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, NO_BATCH);
  }
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
    registerFunction( "substring", new StandardSQLFunction( "substr", StandardBasicTypes.STRING ) );
    registerFunction( "bit_length", new SQLFunctionTemplate( StandardBasicTypes.INTEGER, "length(?1)*8" ) );
    registerFunction( "trim", new AnsiTrimEmulationFunction() );

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

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

    registerKeyword( "current" );
    registerKeyword( "date" );
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    registerFunction( "ceiling", new StandardSQLFunction("ceiling") );
    registerFunction( "floor", new StandardSQLFunction("floor") );

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

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

    registerFunction( "length", new StandardSQLFunction( "len", StandardBasicTypes.INTEGER ) );
    registerFunction( "trim", new SQLFunctionTemplate( StandardBasicTypes.STRING, "ltrim(rtrim(?1))") );
    registerFunction( "locate", new CharIndexFunction() );
View Full Code Here
190
191
192
193
194
195
196
197
198
    // Multi-param dialect functions...
    registerFunction( "mod", new StandardSQLFunction( "mod", Hibernate.INTEGER ) );

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

    getDefaultProperties().setProperty( Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE );
  }
View Full Code Here
26
27
28
29
30
31
32
public class Ingres9Dialect extends IngresDialect {
    public Ingres9Dialect() {
        super();
        registerDateTimeFunctions();
        registerDateTimeColumnTypes();
        registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(", "||", ")" ) );
    }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
    registerFunction( "truncate", new StandardSQLFunction( "truncate", Hibernate.DOUBLE ) );

    // String Functions ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    registerFunction( "ascii", new StandardSQLFunction( "ascii", Hibernate.INTEGER ) );
    registerFunction( "char", new StandardSQLFunction( "char", Hibernate.CHARACTER ) );
    registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(", "||", ")" ) );
    registerFunction( "difference", new StandardSQLFunction( "difference", Hibernate.INTEGER ) );
    registerFunction( "hextoraw", new StandardSQLFunction( "hextoraw", Hibernate.STRING ) );
    registerFunction( "insert", new StandardSQLFunction( "lower", Hibernate.STRING ) );
    registerFunction( "left", new StandardSQLFunction( "left", Hibernate.STRING ) );
    registerFunction( "lcase", new StandardSQLFunction( "lcase", Hibernate.STRING ) );
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
    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", Hibernate.LONG ) );
    registerFunction( "charextract", new StandardSQLFunction( "charextract", Hibernate.STRING ) );
    registerFunction( "concat", new VarArgsSQLFunction( Hibernate.STRING, "(", "+", ")" ) );
    registerFunction( "cos", new StandardSQLFunction( "cos", Hibernate.DOUBLE ) );
    registerFunction( "current_user", new NoArgSQLFunction( "current_user", Hibernate.STRING, false ) );
    registerFunction( "current_time", new NoArgSQLFunction( "date('now')", Hibernate.TIMESTAMP, false ) );
    registerFunction( "current_timestamp", new NoArgSQLFunction( "date('now')", Hibernate.TIMESTAMP, false ) );
    registerFunction( "current_date", new NoArgSQLFunction( "date('now')", Hibernate.TIMESTAMP, false ) );
View Full Code Here
TOP

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

  • com.mysema.query.jpa.support.ExtendedDerbyDialect
  • com.mysema.query.jpa.support.TeradataDialect
  • org.geoserver.hibernate.H2Dialect
  • org.geoserver.monitor.hib.H2Dialect
  • org.hibernate.dialect.AbstractHANADialect
  • org.hibernate.dialect.AbstractTransactSQLDialect
  • org.hibernate.dialect.Cache71Dialect
  • org.hibernate.dialect.CUBRIDDialect
  • org.hibernate.dialect.CUBRIDExDialect
  • org.hibernate.dialect.DB2Dialect
    • 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.