Uses of Interface
org.datanucleus.store.rdbms.sql.method.SQLMethod

Packages that use SQLMethod

Package	Description
org.datanucleus.store.rdbms.sql.expression	Series of expressions representing conditions in SQL statements.
org.datanucleus.store.rdbms.sql.method	Support for invocation of Java methods, typically using SQL functions.

Uses of SQLMethod in org.datanucleus.store.rdbms.sql.expression

Methods in org.datanucleus.store.rdbms.sql.expression that return SQLMethod

Modifier and Type	Method	Description
protected SQLMethod	SQLExpressionFactory.getMethod(String className, String methodName, List args)	Accessor for the method defined by the class/method names and supplied args.

Methods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLMethod

Modifier and Type	Method	Description
void	SQLExpressionFactory.registerMethod(String className, String methodName, SQLMethod method)	Method to allow a user to register an SQLMethod at runtime without utilising the plugin mechanism.

Uses of SQLMethod in org.datanucleus.store.rdbms.sql.method

Classes in org.datanucleus.store.rdbms.sql.method that implement SQLMethod

Modifier and Type	Class	Description
class	AbsFunction	Expression handler to invoke the SQL ABS function.
class	AcosFunction	Expression handler to invoke the SQL ACOS function.
class	ArrayContainsMethod	Method for evaluating {arrExpr}.contains(elemExpr).
class	ArrayIsEmptyMethod	Method for evaluating {arrExpr1}.isEmpty().
class	ArraySizeMethod	Method for evaluating {arrExpr1}.size().
class	AsinFunction	Expression handler to invoke the SQL ASIN function.
class	Atan2Function	Expression handler to invoke the SQL ATAN2 function.
class	AtanFunction	Expression handler to invoke the SQL ATAN function.
class	AvgFunction	Expression handler to invoke the SQL AVG aggregation function.
class	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.
class	CeilFunction	Expression handler to invoke the SQL CEIL function.
class	CoalesceFunction	Expression handler to invoke the SQL COALESCE function.
class	CollectionContainsMethod	Method for evaluating {collExpr1}.contains({elemExpr}).
class	CollectionIsEmptyMethod	Method for evaluating {collExpr1}.isEmpty().
class	CollectionSizeMethod	Method for evaluating {collExpr1}.size().
class	CosFunction	Expression handler to invoke the SQL COS function.
class	CoshFunction	Expression handler to invoke the SQL COSH function.
class	CotFunction	Expression handler to invoke the SQL COT function.
class	CountFunction	Expression handler to invoke the SQL COUNT aggregation function.
class	CountStarFunction	Expression handler to invoke the SQL COUNT(*) aggregation function.
class	CurrentDateFunction	Expression handler to invoke the SQL CURRENT_DATE function.
class	CurrentTimeFunction	Expression handler to invoke the SQL CURRENT_TIME function.
class	CurrentTimestampFunction	Expression handler to invoke the SQL CURRENT_TIMESTAMP function.
class	DegreesFunction	Expression handler to invoke the SQL DEGREES function.
class	EnumOrdinalMethod	Expression handler to evaluate {enumExpression}.ordinal().
class	EnumToStringMethod	Expression handler to evaluate {enumExpression}.toString().
class	ExpFunction	Expression handler to invoke the SQL EXP function.
class	FloorFunction	Expression handler to invoke the SQL FLOOR function.
class	JDOHelperGetObjectIdMethod	Expression handler to evaluate JDOHelper.getObjectId({expression}).
class	JDOHelperGetVersionMethod	Expression handler to evaluate JDOHelper.getVersion({expression}).
class	ListGetMethod	Method for evaluating {listExpr}.get(idxExpr).
class	ListIndexOfMethod	Method for evaluating {listExpr}.indexOf(elemExpr) and JPQL "INDEX(elem)" Returns a NumericExpression representing the index
class	LocalDateFunction	Expression handler to invoke the SQL CURRENT_DATE function and return as a LocalDate.
class	LocalDateTimeFunction	Expression handler to invoke the SQL CURRENT_TIMESTAMP function and return as LocalDateTime.
class	LocalTimeFunction	Expression handler to invoke the SQL CURRENT_TIME function and return as LocalTime.
class	LogFunction	Expression handler to invoke the SQL LOG function.
class	LogFunction2	Expression handler to invoke the SQL (natural) LOG function.
class	MapContainsEntryMethod	Method for evaluating {mapExpr}.containsEntry(keyExpr, valueExpr).
class	MapContainsKeyMethod	Method for evaluating {mapExpr}.containsKey(keyExpr).
class	MapContainsValueMethod	Method for evaluating {mapExpr}.containsValue(valueExpr).
class	MapGetMethod	Method for evaluating {mapExpr}.get(keyExpr).
class	MapIsEmptyMethod	Method for evaluating {mapExpr}.isEmpty().
class	MapKeyMethod	Method for evaluating KEY({mapExpr}).
class	MapSizeMethod	Method for evaluating {mapExpr}.size().
class	MapValueMethod	Method for evaluating VALUE({mapExpr}).
class	MathAbsMethod	Expression handler to evaluate Math.abs({expression}).
class	MathAcosMethod	Expression handler to evaluate Math.acos({expression}).
class	MathAsinMethod	Expression handler to evaluate Math.asin({expression}).
class	MathAtanMethod	Expression handler to evaluate Math.atan({expression}).
class	MathCeilMethod	Expression handler to evaluate Math.ceil({expression}).
class	MathCosMethod	Expression handler to evaluate Math.cos({expression}).
class	MathExpMethod	Expression handler to evaluate Math.exp({expression}).
class	MathFloorMethod	Expression handler to evaluate Math.floor({expression}).
class	MathLogMethod	Expression handler to evaluate Math.log({expression}).
class	MathPowerMethod	Expression handler to evaluate Math.power({expression}).
class	MathSinMethod	Expression handler to evaluate Math.sin({expression}).
class	MathSqrtMethod	Expression handler to evaluate Math.sqrt({expression}).
class	MathTanMethod	Expression handler to evaluate Math.tan({expression}).
class	MathToDegreesMethod	Expression handler to evaluate Math.toDegrees({expression}).
class	MathToRadiansMethod	Expression handler to evaluate Math.toRadians({expression}).
class	MaxFunction	Expression handler to invoke the SQL MAX aggregation function.
class	MinFunction	Expression handler to invoke the SQL MIN aggregation function.
class	NullIfFunction	Expression handler to invoke the SQL NULLIF function.
class	ObjectGetClassMethod	Expression handler to evaluate {objectExpression}.getClass().
class	OptionalGetMethod	Method for evaluating {optionalExpr1}.get().
class	OptionalIsPresentMethod	Method for evaluating {optionalExpr1}.isPresent().
class	OptionalOrElseMethod	Method for evaluating {optionalExpr1}.orElse().
class	PowerFunction	Expression handler to invoke the SQL POWER function.
class	RadiansFunction	Expression handler to invoke the SQL RADIANS function.
class	RoundMethod	Expression handler to evaluate ROUND({expression}[,{decimalPlaces}]).
class	SignFunction	Expression handler to invoke the SQL SIGN function.
class	SimpleNumericAggregateMethod	Expression handler to invoke an SQL aggregated function.
class	SimpleNumericMethod	Expression handler to invoke an SQL numeric function that takes in argument(s).
class	SimpleOrderableAggregateMethod	Expression handler to invoke an SQL aggregated function.
class	SimpleStringMethod	Expression handler to invoke an SQL String function that takes in an expression.
class	SinFunction	Expression handler to invoke the SQL SIN function.
class	SinhFunction	Expression handler to invoke the SQL SINH function.
class	SQLBooleanMethod	Method to allow inclusion of any SQL code that returns a boolean.
class	SQLCubeFunction	Expression handler to evaluate SQL.cube(args).
class	SQLFunctionMethod	Method to allow inclusion of any SQL function invocation.
class	SQLNumericMethod	Method to allow inclusion of any SQL code that returns a numeric.
class	SQLRollupFunction	Expression handler to evaluate SQL.rollup(args).
class	SqrtFunction	Expression handler to invoke the SQL SQRT function.
class	StringCharAt2Method	Method for evaluating {strExpr}.charAt(numExpr).
class	StringCharAtMethod	Method for evaluating {strExpr}.charAt(numExpr).
class	StringConcat1Method	Method for evaluating {strExpr}.concat(strExpr1s).
class	StringConcat2Method	Method for evaluating {strExpr}.concat(strExpr1s).
class	StringEndsWith2Method	Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]) for Cloud Spanner.
class	StringEndsWithMethod	Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]).
class	StringEqualsIgnoreCaseMethod	Method for evaluating {strExpr1}.equalsIgnoreCase(strExpr2).
class	StringEqualsMethod	Method for evaluating {strExpr1}.equals(strExpr2).
class	StringIndexOf2Method	Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
class	StringIndexOf3Method	Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
class	StringIndexOf4Method	Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
class	StringIndexOf5Method	Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]) for PostgreSQL.
class	StringIndexOfMethod	Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
class	StringLength2Method	Expression handler to evaluate {stringExpression}.length() with Firebird.
class	StringLength3Method	Expression handler to evaluate {stringExpression}.length().
class	StringLength4Method	Expression handler to evaluate {stringExpression}.length().
class	StringLengthMethod	Expression handler to evaluate {stringExpression}.length().
class	StringMatchesDerbyMethod	Expression handler to evaluate {stringExpression}.matches(StringExpression) for Derby.
class	StringMatchesMethod	Expression handler to evaluate {stringExpression}.matches(StringExpression).
class	StringReplaceAllMethod	Method for evaluating {strExpr}.replaceAll(strExpr1, strExpr2).
class	StringSimilarPostgresqlMethod	Support for a String.matches like functionality but using Postgresql's "SIMILAR TO" operator.
class	StringStartsWith2Method	Method for evaluating {strExpr1}.startsWith(strExpr2).
class	StringStartsWith3Method	Method for evaluating {strExpr1}.startsWith(strExpr2[,numExpr]).
class	StringStartsWith4Method	Method for evaluating {strExpr1}.startsWith(strExpr2) for cloud spanner.
class	StringStartsWithMethod	Method for evaluating {strExpr1}.startsWith(strExpr2[, numExpr]).
class	StringSubstring2Method	Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
class	StringSubstring3Method	Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
class	StringSubstring4Method	Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
class	StringSubstring5Method	Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
class	StringSubstringMethod	Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).
class	StringToLowerMethod	Expression handler to invoke the SQL LOWER function.
class	StringToUpperMethod	Expression handler to invoke the SQL UPPER function.
class	StringTranslateMethod	Method for evaluating {strExpr}.translate(strExpr1, strExpr2).
class	StringTrim2Method	Method for trimming a String expression using LTRIM and RTRIM SQL functions.
class	StringTrim3Method	Method for evaluating {strExpr1}.trim() or "TRIM(BOTH trimChar FROM strExpr1)".
class	StringTrimLeft3Method	Method for evaluating {strExpr1}.trimLeft() or "TRIM(LEADING trimChar FROM strExpr1)".
class	StringTrimLeftMethod	Expression handler to invoke the SQL LTRIM function.
class	StringTrimMethod	Expression handler to invoke the SQL TRIM function.
class	StringTrimRight3Method	Method for evaluating {strExpr1}.trimLeft() or "TRIM(TRAILING trimChar FROM strExpr1)".
class	StringTrimRightMethod	Expression handler to invoke the SQL RTRIM function.
class	SumFunction	Expression handler to invoke the SQL SUM aggregation function.
class	TanFunction	Expression handler to invoke the SQL TAN function.
class	TanhFunction	Expression handler to invoke the SQL TANH function.
class	TemporalBaseMethod	Base for all temporal methods.
class	TemporalDayMethod	Method for evaluating DAY({dateExpr}).
class	TemporalDayMethod2	Method for evaluating DAY({dateExpr}) using Oracle.
class	TemporalDayMethod3	Method for evaluating DAY({dateExpr}) using PostgreSQL.
class	TemporalDayMethod4	Method for evaluating {dateExpr}.getDay() using SQLite.
class	TemporalDayMethod5	Method for evaluating {dateExpr}.getDay() for Firebird and CloudSpanner.
class	TemporalDayOfWeekMethod	Method for evaluating DAY_OF_WEEK({dateExpr}) using H2.
class	TemporalDayOfWeekMethod2	Method for evaluating DAY_OF_WEEK({dateExpr}) using PostgreSQL.
class	TemporalDayOfWeekMethod3	Method for evaluating DAY_OF_WEEK({dateExpr}) using MySQL.
class	TemporalDayOfWeekMethod4	Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLServer.
class	TemporalDayOfWeekMethod5	Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLite.
class	TemporalDayOfWeekMethod6	Method for evaluating DAY_OF_WEEK({dateExpr}) for Firebird.
class	TemporalDayOfWeekMethod7	Method for evaluating DAY_OF_WEEK({dateExpr}) for CloudSpanner.
class	TemporalDayOfYearMethod	Method for evaluating DAYOFYEAR({dateExpr}) for CloudSpanner.
class	TemporalHourMethod	Method for evaluating HOUR({dateExpr}).
class	TemporalHourMethod2	Method for evaluating HOUR({dateExpr}) using Oracle.
class	TemporalHourMethod3	Method for evaluating HOUR({dateExpr}) using PostgreSQL.
class	TemporalHourMethod4	Method for evaluating HOUR({dateExpr}) using SQLServer.
class	TemporalHourMethod5	Method for evaluating HOUR({dateExpr}) using SQLite.
class	TemporalHourMethod6	Method for evaluating HOUR({dateExpr}) for Firebird and CloudSpanner.
class	TemporalIsoWeekMethod	Method for evaluating ISOWEEK({dateExpr}) for CloudSpanner.
class	TemporalIsoYearMethod	Method for evaluating ISOYEAR({dateExpr}) for CloudSpanner.
class	TemporalMilliSecondMethod	Method for evaluating MILLISECOND({dateExpr}) for CloudSpanner.
class	TemporalMinuteMethod	Method for evaluating MINUTE({dateExpr}).
class	TemporalMinuteMethod2	Method for evaluating MINUTE({dateExpr}) using Oracle.
class	TemporalMinuteMethod3	Method for evaluating {dateExpr}.getMinute() using PostgreSQL.
class	TemporalMinuteMethod4	Method for evaluating MINUTE({dateExpr}) using SQLServer.
class	TemporalMinuteMethod5	Method for evaluating MINUTE({dateExpr}) using SQLite.
class	TemporalMinuteMethod6	Method for evaluating MINUTE({dateExpr}) for Firebird and CloudSpanner.
class	TemporalMonthJavaMethod	Method for evaluating {dateExpr}.getMonth().
class	TemporalMonthJavaMethod2	Method for evaluating {dateExpr}.getMonth().
class	TemporalMonthJavaMethod3	Method for evaluating {dateExpr}.getMonth() using PostgreSQL.
class	TemporalMonthJavaMethod4	Method for evaluating {dateExpr}.getMonth() using SQLite.
class	TemporalMonthJavaMethod5	Method for evaluating {dateExpr}.getMonth() for Firebird and CloudSpanner.
class	TemporalMonthMethod	Method for evaluating MONTH({dateExpr}).
class	TemporalMonthMethod2	Method for evaluating MONTH({dateExpr}) using Oracle.
class	TemporalMonthMethod3	Method for evaluating MONTH({dateExpr}) using PostgreSQL.
class	TemporalMonthMethod4	Method for evaluating MONTH({dateExpr}) using SQLite.
class	TemporalMonthMethod5	Method for evaluating MONTH({dateExpr}) for Firebird and CloudSpanner.
class	TemporalQuarterMethod	Method for evaluating QUARTER({dateExpr}).
class	TemporalQuarterMethod2	Method for evaluating QUARTER({dateExpr}) using Oracle.
class	TemporalQuarterMethod3	Method for evaluating QUARTER({dateExpr}) using PostgreSQL.
class	TemporalQuarterMethod4	Method for evaluating QUARTER({dateExpr}) using SQLServer.
class	TemporalQuarterMethod5	Method for evaluating QUARTER({dateExpr}) for CloudSpanner.
class	TemporalSecondMethod	Method for evaluating SECOND({dateExpr}).
class	TemporalSecondMethod2	Method for evaluating SECOND({dateExpr}) using Oracle.
class	TemporalSecondMethod3	Method for evaluating SECOND({dateExpr}) using PostgreSQL.
class	TemporalSecondMethod4	Method for evaluating SECOND({dateExpr}) using SQLServer.
class	TemporalSecondMethod5	Method for evaluating SECOND({dateExpr}).
class	TemporalSecondMethod6	Method for evaluating SECOND({dateExpr}) using SQLite.
class	TemporalSecondMethod7	Method for evaluating SECOND({dateExpr}) for Firebird and CloudSpanner.
class	TemporalWeekMethod	Method for evaluating WEEK({dateExpr}).
class	TemporalWeekMethod2	Method for evaluating WEEK({dateExpr}) using Sybase.
class	TemporalWeekMethod3	Method for evaluating WEEK({dateExpr}) using PostgreSQL.
class	TemporalWeekMethod4	Method for evaluating WEEK({dateExpr}) using SQLServer.
class	TemporalWeekMethod5	Method for evaluating WEEK({dateExpr}) for Firebird and CloudSpanner.
class	TemporalWeekMethod6	Method for evaluating WEEK({dateExpr}) using Oracle.
class	TemporalYearMethod	Method for evaluating YEAR({dateExpr}).
class	TemporalYearMethod2	Method for evaluating YEAR({dateExpr}) using Oracle.
class	TemporalYearMethod3	Method for evaluating YEAR({dateExpr}).
class	TemporalYearMethod4	Method for evaluating YEAR({dateExpr}) using SQLite.
class	TemporalYearMethod5	Method for evaluating YEAR({dateExpr}) for Firebird and CloudSpanner.