See: Description
| Interface | Description |
|---|---|
| SQLMethod |
Interface to implement to wrap an SQL function.
|
| Class | Description |
|---|---|
| AbsFunction |
Expression handler to invoke the SQL ABS function.
|
| AbstractSQLMethod |
Abstract implementation of an SQLMethod.
|
| AcosFunction |
Expression handler to invoke the SQL ACOS function.
|
| ArrayContainsMethod |
Method for evaluating {arrExpr}.contains(elemExpr).
|
| ArrayIsEmptyMethod |
Method for evaluating {arrExpr1}.isEmpty().
|
| ArraySizeMethod |
Method for evaluating {arrExpr1}.size().
|
| AsinFunction |
Expression handler to invoke the SQL ASIN function.
|
| AtanFunction |
Expression handler to invoke the SQL ATAN function.
|
| AvgFunction |
Expression handler to invoke the SQL AVG aggregation function.
|
| AvgWithCastFunction |
Some databases will use the same type for the return value as the argument, which can be an issue
when averaging on integral types since it will drop the decimals.
|
| CeilFunction |
Expression handler to invoke the SQL CEIL function.
|
| CoalesceFunction |
Expression handler to invoke the SQL COALESCE function.
|
| CollectionContainsMethod |
Method for evaluating {collExpr1}.contains({elemExpr}).
|
| CollectionIsEmptyMethod |
Method for evaluating {collExpr1}.isEmpty().
|
| CollectionSizeMethod |
Method for evaluating {collExpr1}.size().
|
| CosFunction |
Expression handler to invoke the SQL COS function.
|
| CountFunction |
Expression handler to invoke the SQL COUNT aggregation function.
|
| CountStarFunction |
Expression handler to invoke the SQL COUNT(*) aggregation function.
|
| CurrentDateFunction |
Expression handler to invoke the SQL CURRENT_DATE function.
|
| CurrentTimeFunction |
Expression handler to invoke the SQL CURRENT_TIME function.
|
| CurrentTimestampFunction |
Expression handler to invoke the SQL CURRENT_TIMESTAMP function.
|
| DateGetDay2Method |
Method for evaluating {dateExpr}.getDay().
|
| DateGetDay3Method |
Method for evaluating {dateExpr}.getDay() using PostgreSQL.
|
| DateGetDayMethod |
Method for evaluating {dateExpr}.getDay().
|
| DateGetHour2Method |
Method for evaluating {dateExpr}.getHour().
|
| DateGetHour3Method |
Method for evaluating {dateExpr}.getHour() using PostgreSQL.
|
| DateGetHour4Method |
Method for evaluating {dateExpr}.getHour() using MSSQL.
|
| DateGetHour5Method |
Method for evaluating {dateExpr}.getHour() using SQLite.
|
| DateGetHour6Method |
Method for evaluating {dateExpr}.getHour() for Firebird.
|
| DateGetHourMethod |
Method for evaluating {dateExpr}.getHour().
|
| DateGetMinute2Method |
Method for evaluating {dateExpr}.getMinute().
|
| DateGetMinute3Method |
Method for evaluating {dateExpr}.getMinute() using PostgreSQL.
|
| DateGetMinute4Method |
Method for evaluating {dateExpr}.getMinute() using MSSQL.
|
| DateGetMinute5Method |
Method for evaluating {dateExpr}.getMinute() using SQLite.
|
| DateGetMinute6Method |
Method for evaluating {dateExpr}.getMinute() for Firebird.
|
| DateGetMinuteMethod |
Method for evaluating {dateExpr}.getMinute().
|
| DateGetMonth2Method |
Method for evaluating {dateExpr}.getMonth().
|
| DateGetMonth3Method |
Method for evaluating {dateExpr}.getMonth() using PostgreSQL.
|
| DateGetMonth4Method |
Method for evaluating {dateExpr}.getMonth() using SQLite.
|
| DateGetMonth5Method |
Method for evaluating {dateExpr}.getMonth() for Firebird.
|
| DateGetMonthMethod |
Method for evaluating {dateExpr}.getMonth().
|
| DateGetSecond2Method |
Method for evaluating {dateExpr}.getSecond().
|
| DateGetSecond3Method |
Method for evaluating {dateExpr}.getSecond() using PostgreSQL.
|
| DateGetSecond4Method |
Method for evaluating {dateExpr}.getSecond() using SQLServer.
|
| DateGetSecond5Method |
Method for evaluating {dateExpr}.getSecond().
|
| DateGetSecond6Method |
Method for evaluating {dateExpr}.getSecond() using SQLite.
|
| DateGetSecond7Method |
Method for evaluating {dateExpr}.getSecond() for Firebird.
|
| DateGetSecondMethod |
Method for evaluating {dateExpr}.getSecond().
|
| DateGetYear2Method |
Method for evaluating {dateExpr}.getYear().
|
| DateGetYear3Method |
Method for evaluating {dateExpr}.getYear().
|
| DateGetYear4Method |
Method for evaluating {dateExpr}.getYear() using SQLite.
|
| DateGetYear5Method |
Method for evaluating {dateExpr}.getYear() for Firebird.
|
| DateGetYearMethod |
Method for evaluating {dateExpr}.getYear().
|
| DegreesFunction |
Expression handler to invoke the SQL DEGREES function.
|
| EnumOrdinalMethod |
Expression handler to evaluate {enumExpression}.ordinal().
|
| EnumToStringMethod |
Expression handler to evaluate {enumExpression}.toString().
|
| ExpFunction |
Expression handler to invoke the SQL EXP function.
|
| FloorFunction |
Expression handler to invoke the SQL FLOOR function.
|
| IndexFunction |
Expression handler for JPQL "INDEX" expression to return the index of an element.
|
| JDOHelperGetObjectIdMethod |
Expression handler to evaluate JDOHelper.getObjectId({expression}).
|
| JDOHelperGetVersionMethod |
Expression handler to evaluate JDOHelper.getVersion({expression}).
|
| ListGetMethod |
Method for evaluating {listExpr}.get(idxExpr).
|
| LogFunction |
Expression handler to invoke the SQL LOG function.
|
| LogFunction2 |
Expression handler to invoke the SQL (natural) LOG function.
|
| MapContainsEntryMethod |
Method for evaluating {mapExpr}.containsEntry(keyExpr, valueExpr).
|
| MapContainsKeyMethod |
Method for evaluating {mapExpr}.containsKey(keyExpr).
|
| MapContainsValueMethod |
Method for evaluating {mapExpr}.containsValue(valueExpr).
|
| MapGetMethod |
Method for evaluating {mapExpr}.get(keyExpr).
|
| MapIsEmptyMethod |
Method for evaluating {mapExpr}.isEmpty().
|
| MapKeyMethod |
Method for evaluating KEY({mapExpr}).
|
| MapSizeMethod |
Method for evaluating {mapExpr}.size().
|
| MapValueMethod |
Method for evaluating VALUE({mapExpr}).
|
| MathAbsMethod |
Expression handler to evaluate Math.abs({expression}).
|
| MathAcosMethod |
Expression handler to evaluate Math.acos({expression}).
|
| MathAsinMethod |
Expression handler to evaluate Math.asin({expression}).
|
| MathAtanMethod |
Expression handler to evaluate Math.atan({expression}).
|
| MathCeilMethod |
Expression handler to evaluate Math.ceil({expression}).
|
| MathCosMethod |
Expression handler to evaluate Math.cos({expression}).
|
| MathExpMethod |
Expression handler to evaluate Math.exp({expression}).
|
| MathFloorMethod |
Expression handler to evaluate Math.floor({expression}).
|
| MathLogMethod |
Expression handler to evaluate Math.log({expression}).
|
| MathSinMethod |
Expression handler to evaluate Math.sin({expression}).
|
| MathSqrtMethod |
Expression handler to evaluate Math.sqrt({expression}).
|
| MathTanMethod |
Expression handler to evaluate Math.tan({expression}).
|
| MathToDegreesMethod |
Expression handler to evaluate Math.toDegrees({expression}).
|
| MathToRadiansMethod |
Expression handler to evaluate Math.toRadians({expression}).
|
| MaxFunction |
Expression handler to invoke the SQL MAX aggregation function.
|
| MinFunction |
Expression handler to invoke the SQL MIN aggregation function.
|
| NullIfFunction |
Expression handler to invoke the SQL NULLIF function.
|
| ObjectGetClassMethod |
Expression handler to evaluate {objectExpression}.getClass().
|
| RadiansFunction |
Expression handler to invoke the SQL RADIANS function.
|
| SimpleNumericAggregateMethod |
Expression handler to invoke an SQL aggregated function.
|
| SimpleNumericMethod |
Expression handler to invoke an SQL numeric function that takes in argument(s).
|
| SimpleOrderableAggregateMethod |
Expression handler to invoke an SQL aggregated function.
|
| SimpleStringMethod |
Expression handler to invoke an SQL String function that takes in an expression.
|
| SinFunction |
Expression handler to invoke the SQL SIN function.
|
| SQLBooleanMethod |
Method to allow inclusion of any SQL code that returns a boolean.
|
| SQLCubeFunction |
Expression handler to evaluate SQL.cube(args).
|
| SQLFunctionMethod |
Method to allow inclusion of any SQL function invocation.
|
| SQLNumericMethod |
Method to allow inclusion of any SQL code that returns a numeric.
|
| SQLRollupFunction |
Expression handler to evaluate SQL.rollup(args).
|
| SqrtFunction |
Expression handler to invoke the SQL SQRT function.
|
| StringCharAtMethod |
Method for evaluating {strExpr}.charAt(numExpr).
|
| StringConcat1Method |
Method for evaluating {strExpr}.concat(strExpr1s).
|
| StringConcat2Method |
Method for evaluating {strExpr}.concat(strExpr1s).
|
| StringEndsWithMethod |
Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]).
|
| StringEqualsIgnoreCaseMethod |
Method for evaluating {strExpr1}.equalsIgnoreCase(strExpr2).
|
| StringEqualsMethod |
Method for evaluating {strExpr1}.equals(strExpr2).
|
| StringIndexOf2Method |
Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
|
| StringIndexOf3Method |
Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
|
| StringIndexOf4Method |
Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
|
| StringIndexOf5Method |
Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]) for PostgreSQL.
|
| StringIndexOfMethod |
Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
|
| StringLength2Method |
Expression handler to evaluate {stringExpression}.length() with Firebird.
|
| StringLength3Method |
Expression handler to evaluate {stringExpression}.length().
|
| StringLength4Method |
Expression handler to evaluate {stringExpression}.length().
|
| StringLengthMethod |
Expression handler to evaluate {stringExpression}.length().
|
| StringMatchesDerbyMethod |
Expression handler to evaluate {stringExpression}.matches(StringExpression) for Derby.
|
| StringMatchesMethod |
Expression handler to evaluate {stringExpression}.matches(StringExpression).
|
| StringReplaceAllMethod |
Method for evaluating {strExpr}.replaceAll(strExpr1, strExpr2).
|
| StringSimilarPostgresqlMethod |
Support for a String.matches like functionality but using Postgresql's "SIMILAR TO" operator.
|
| StringStartsWith2Method |
Method for evaluating {strExpr1}.startsWith(strExpr2).
|
| StringStartsWith3Method |
Method for evaluating {strExpr1}.startsWith(strExpr2[,numExpr]).
|
| StringStartsWithMethod |
Method for evaluating {strExpr1}.startsWith(strExpr2[, numExpr]).
|
| StringSubstring2Method |
Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
|
| StringSubstring3Method |
Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
|
| StringSubstring4Method |
Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
|
| StringSubstring5Method |
Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
|
| StringSubstringMethod |
Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
|
| StringToLowerMethod |
Expression handler to invoke the SQL LOWER function.
|
| StringToUpperMethod |
Expression handler to invoke the SQL UPPER function.
|
| StringTranslateMethod |
Method for evaluating {strExpr}.translate(strExpr1, strExpr2).
|
| StringTrim2Method |
Method for trimming a String expression using LTRIM and RTRIM SQL functions.
|
| StringTrim3Method |
Method for evaluating {strExpr1}.trim() or "TRIM(BOTH trimChar FROM strExpr1)".
|
| StringTrimLeft3Method |
Method for evaluating {strExpr1}.trimLeft() or "TRIM(LEADING trimChar FROM strExpr1)".
|
| StringTrimLeftMethod |
Expression handler to invoke the SQL LTRIM function.
|
| StringTrimMethod |
Expression handler to invoke the SQL TRIM function.
|
| StringTrimRight3Method |
Method for evaluating {strExpr1}.trimLeft() or "TRIM(TRAILING trimChar FROM strExpr1)".
|
| StringTrimRightMethod |
Expression handler to invoke the SQL RTRIM function.
|
| SumFunction |
Expression handler to invoke the SQL SUM aggregation function.
|
| TanFunction |
Expression handler to invoke the SQL TAN function.
|
Support for invocation of Java methods, typically using SQL functions. Registered using the plugin-point org.datanucleus.store.rdbms.sql_method allowing users to register handling for particular methods to override/extend the default behaviour. All RDBMS have their own set of SQL functions and this is typically used to provide for all different possible SQL functions and tie them to a datastore.
Copyright © 2017. All rights reserved.