See: Description
| Interface | Description |
|---|---|
| SQLMethod |
Interface to implement to wrap an SQL function.
|
| Class | Description |
|---|---|
| AbsFunction |
Expression handler to invoke the SQL ABS function.
|
| 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.
|
| 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).
|
| ListIndexOfMethod |
Method for evaluating {listExpr}.indexOf(elemExpr).
|
| 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}).
|
| MathPowerMethod |
Expression handler to evaluate Math.power({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().
|
| OptionalGetMethod |
Method for evaluating {optionalExpr1}.get().
|
| OptionalIsPresentMethod |
Method for evaluating {optionalExpr1}.isPresent().
|
| OptionalOrElseMethod |
Method for evaluating {optionalExpr1}.orElse().
|
| PowerFunction |
Expression handler to invoke the SQL POWER function.
|
| 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.
|
| TemoralMinuteMethod6 |
Method for evaluating {dateExpr}.getMinute() for Firebird.
|
| TemporalBaseMethod |
Base for all temporal methods.
|
| TemporalDayMethod |
Method for evaluating DAY({dateExpr}).
|
| TemporalDayMethod2 |
Method for evaluating DAY({dateExpr}).
|
| TemporalDayMethod3 |
Method for evaluating DAY({dateExpr}) using PostgreSQL.
|
| TemporalDayMethod4 |
Method for evaluating {dateExpr}.getDay() using SQLite.
|
| TemporalDayMethod5 |
Method for evaluating {dateExpr}.getDay() for Firebird.
|
| TemporalDayOfWeekMethod |
Method for evaluating DAY_OF_WEEK({dateExpr}) using H2.
|
| TemporalDayOfWeekMethod2 |
Method for evaluating DAY_OF_WEEK({dateExpr}) using PostgreSQL.
|
| TemporalDayOfWeekMethod3 |
Method for evaluating DAY_OF_WEEK({dateExpr}) using MySQL.
|
| TemporalDayOfWeekMethod4 |
Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLServer.
|
| TemporalDayOfWeekMethod5 |
Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLite.
|
| TemporalDayOfWeekMethod6 |
Method for evaluating DAY_OF_WEEK({dateExpr}) for Firebird.
|
| TemporalHourMethod |
Method for evaluating HOUR({dateExpr}).
|
| TemporalHourMethod2 |
Method for evaluating HOUR({dateExpr}).
|
| TemporalHourMethod3 |
Method for evaluating HOUR({dateExpr}) using PostgreSQL.
|
| TemporalHourMethod4 |
Method for evaluating HOUR({dateExpr}) using SQLServer.
|
| TemporalHourMethod5 |
Method for evaluating HOUR({dateExpr}) using SQLite.
|
| TemporalHourMethod6 |
Method for evaluating HOUR({dateExpr}) for Firebird.
|
| TemporalMinuteMethod |
Method for evaluating MINUTE({dateExpr}).
|
| TemporalMinuteMethod2 |
Method for evaluating MINUTE({dateExpr}).
|
| TemporalMinuteMethod3 |
Method for evaluating {dateExpr}.getMinute() using PostgreSQL.
|
| TemporalMinuteMethod4 |
Method for evaluating MINUTE({dateExpr}) using SQLServer.
|
| TemporalMinuteMethod5 |
Method for evaluating MINUTE({dateExpr}) using SQLite.
|
| TemporalMinuteMethod6 |
Method for evaluating MINUTE({dateExpr}) for Firebird.
|
| TemporalMonthJavaMethod |
Method for evaluating {dateExpr}.getMonth().
|
| TemporalMonthJavaMethod2 |
Method for evaluating {dateExpr}.getMonth().
|
| TemporalMonthJavaMethod3 |
Method for evaluating {dateExpr}.getMonth() using PostgreSQL.
|
| TemporalMonthJavaMethod4 |
Method for evaluating {dateExpr}.getMonth() using SQLite.
|
| TemporalMonthJavaMethod5 |
Method for evaluating {dateExpr}.getMonth() for Firebird.
|
| TemporalMonthMethod |
Method for evaluating MONTH({dateExpr}).
|
| TemporalMonthMethod2 |
Method for evaluating MONTH({dateExpr}).
|
| TemporalMonthMethod3 |
Method for evaluating MONTH({dateExpr}) using PostgreSQL.
|
| TemporalMonthMethod4 |
Method for evaluating MONTH({dateExpr}) using SQLite.
|
| TemporalMonthMethod5 |
Method for evaluating MONTH({dateExpr}) for Firebird.
|
| TemporalSecondMethod |
Method for evaluating SECOND({dateExpr}).
|
| TemporalSecondMethod2 |
Method for evaluating SECOND({dateExpr}).
|
| TemporalSecondMethod3 |
Method for evaluating SECOND({dateExpr}) using PostgreSQL.
|
| TemporalSecondMethod4 |
Method for evaluating SECOND({dateExpr}) using SQLServer.
|
| TemporalSecondMethod5 |
Method for evaluating SECOND({dateExpr}).
|
| TemporalSecondMethod6 |
Method for evaluating SECOND({dateExpr}) using SQLite.
|
| TemporalSecondMethod7 |
Method for evaluating SECOND({dateExpr}) for Firebird.
|
| TemporalYearMethod |
Method for evaluating YEAR({dateExpr}).
|
| TemporalYearMethod2 |
Method for evaluating YEAR({dateExpr}).
|
| TemporalYearMethod3 |
Method for evaluating YEAR({dateExpr}).
|
| TemporalYearMethod4 |
Method for evaluating YEAR({dateExpr}) using SQLite.
|
| TemporalYearMethod5 |
Method for evaluating YEAR({dateExpr}) for Firebird.
|
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 © 2019. All rights reserved.