Package org.datanucleus.store.rdbms.sql.method
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.
-
Interface Summary Interface Description SQLMethod Interface to implement to wrap an SQL function. -
Class Summary 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.Atan2Function Expression handler to invoke the SQL ATAN2 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.CoshFunction Expression handler to invoke the SQL COSH function.CotFunction Expression handler to invoke the SQL COT 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.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) and JPQL "INDEX(elem)" Returns a NumericExpression representing the indexLocalDateFunction Expression handler to invoke the SQL CURRENT_DATE function and return as a LocalDate.LocalDateTimeFunction Expression handler to invoke the SQL CURRENT_TIMESTAMP function and return as LocalDateTime.LocalTimeFunction Expression handler to invoke the SQL CURRENT_TIME function and return as LocalTime.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.RoundMethod Expression handler to evaluate ROUND({expression}[,{decimalPlaces}]).SignFunction Expression handler to invoke the SQL SIGN 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.SinhFunction Expression handler to invoke the SQL SINH 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.StringCharAt2Method Method for evaluating {strExpr}.charAt(numExpr).StringCharAtMethod Method for evaluating {strExpr}.charAt(numExpr).StringConcat1Method Method for evaluating {strExpr}.concat(strExpr1s).StringConcat2Method Method for evaluating {strExpr}.concat(strExpr1s).StringEndsWith2Method Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]) for Cloud Spanner.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]).StringStartsWith4Method Method for evaluating {strExpr1}.startsWith(strExpr2) for cloud spanner.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.TanhFunction Expression handler to invoke the SQL TANH function.TemporalBaseMethod Base for all temporal methods.TemporalDayMethod Method for evaluating DAY({dateExpr}).TemporalDayMethod2 Method for evaluating DAY({dateExpr}) using Oracle.TemporalDayMethod3 Method for evaluating DAY({dateExpr}) using PostgreSQL.TemporalDayMethod4 Method for evaluating {dateExpr}.getDay() using SQLite.TemporalDayMethod5 Method for evaluating {dateExpr}.getDay() for Firebird and CloudSpanner.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.TemporalDayOfWeekMethod7 Method for evaluating DAY_OF_WEEK({dateExpr}) for CloudSpanner.TemporalDayOfYearMethod Method for evaluating DAYOFYEAR({dateExpr}) for CloudSpanner.TemporalHourMethod Method for evaluating HOUR({dateExpr}).TemporalHourMethod2 Method for evaluating HOUR({dateExpr}) using Oracle.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 and CloudSpanner.TemporalIsoWeekMethod Method for evaluating ISOWEEK({dateExpr}) for CloudSpanner.TemporalIsoYearMethod Method for evaluating ISOYEAR({dateExpr}) for CloudSpanner.TemporalMilliSecondMethod Method for evaluating MILLISECOND({dateExpr}) for CloudSpanner.TemporalMinuteMethod Method for evaluating MINUTE({dateExpr}).TemporalMinuteMethod2 Method for evaluating MINUTE({dateExpr}) using Oracle.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 and CloudSpanner.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 and CloudSpanner.TemporalMonthMethod Method for evaluating MONTH({dateExpr}).TemporalMonthMethod2 Method for evaluating MONTH({dateExpr}) using Oracle.TemporalMonthMethod3 Method for evaluating MONTH({dateExpr}) using PostgreSQL.TemporalMonthMethod4 Method for evaluating MONTH({dateExpr}) using SQLite.TemporalMonthMethod5 Method for evaluating MONTH({dateExpr}) for Firebird and CloudSpanner.TemporalQuarterMethod Method for evaluating QUARTER({dateExpr}).TemporalQuarterMethod2 Method for evaluating QUARTER({dateExpr}) using Oracle.TemporalQuarterMethod3 Method for evaluating QUARTER({dateExpr}) using PostgreSQL.TemporalQuarterMethod4 Method for evaluating QUARTER({dateExpr}) using SQLServer.TemporalQuarterMethod5 Method for evaluating QUARTER({dateExpr}) for CloudSpanner.TemporalSecondMethod Method for evaluating SECOND({dateExpr}).TemporalSecondMethod2 Method for evaluating SECOND({dateExpr}) using Oracle.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 and CloudSpanner.TemporalWeekMethod Method for evaluating WEEK({dateExpr}).TemporalWeekMethod2 Method for evaluating WEEK({dateExpr}) using Sybase.TemporalWeekMethod3 Method for evaluating WEEK({dateExpr}) using PostgreSQL.TemporalWeekMethod4 Method for evaluating WEEK({dateExpr}) using SQLServer.TemporalWeekMethod5 Method for evaluating WEEK({dateExpr}) for Firebird and CloudSpanner.TemporalWeekMethod6 Method for evaluating WEEK({dateExpr}) using Oracle.TemporalYearMethod Method for evaluating YEAR({dateExpr}).TemporalYearMethod2 Method for evaluating YEAR({dateExpr}) using Oracle.TemporalYearMethod3 Method for evaluating YEAR({dateExpr}).TemporalYearMethod4 Method for evaluating YEAR({dateExpr}) using SQLite.TemporalYearMethod5 Method for evaluating YEAR({dateExpr}) for Firebird and CloudSpanner.