Package org.datanucleus.store.rdbms.sql.method
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.
-
ClassDescriptionExpression handler to invoke the SQL ABS function.Expression handler to invoke the SQL ACOS function.Method for evaluating {arrExpr}.contains(elemExpr).Method for evaluating {arrExpr1}.isEmpty().Method for evaluating {arrExpr1}.size().Expression handler to invoke the SQL ASIN function.Expression handler to invoke the SQL ATAN2 function.Expression handler to invoke the SQL ATAN function.Expression handler to invoke the SQL AVG aggregation function.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.Expression handler to invoke the SQL CEIL function.Expression handler to invoke the SQL COALESCE function.Method for evaluating {collExpr1}.contains({elemExpr}).Method for evaluating {collExpr1}.isEmpty().Method for evaluating {collExpr1}.size().Expression handler to invoke the SQL COS function.Expression handler to invoke the SQL COSH function.Expression handler to invoke the SQL COT function.Expression handler to invoke the SQL COUNT aggregation function.Expression handler to invoke the SQL COUNT(*) aggregation function.Expression handler to invoke the SQL CURRENT_DATE function.Expression handler to invoke the SQL CURRENT_TIME function.Expression handler to invoke the SQL CURRENT_TIMESTAMP function.Expression handler to invoke the SQL DEGREES function.Expression handler to evaluate {enumExpression}.ordinal().Expression handler to evaluate {enumExpression}.toString().Expression handler to invoke the SQL EXP function.Expression handler to invoke the SQL FLOOR function.Expression handler to evaluate JDOHelper.getObjectId({expression}).Expression handler to evaluate JDOHelper.getVersion({expression}).Method for evaluating {listExpr}.get(idxExpr).Method for evaluating {listExpr}.indexOf(elemExpr) and JPQL "INDEX(elem)" Returns a NumericExpression representing the indexExpression handler to invoke the SQL CURRENT_DATE function and return as a LocalDate.Expression handler to invoke the SQL CURRENT_TIMESTAMP function and return as LocalDateTime.Expression handler to invoke the SQL CURRENT_TIME function and return as LocalTime.Expression handler to invoke the SQL LOG function.Expression handler to invoke the SQL (natural) LOG function.Method for evaluating {mapExpr}.containsEntry(keyExpr, valueExpr).Method for evaluating {mapExpr}.containsKey(keyExpr).Method for evaluating {mapExpr}.containsValue(valueExpr).Method for evaluating {mapExpr}.get(keyExpr).Method for evaluating {mapExpr}.isEmpty().Method for evaluating KEY({mapExpr}).Method for evaluating {mapExpr}.size().Method for evaluating VALUE({mapExpr}).Expression handler to evaluate Math.abs({expression}).Expression handler to evaluate Math.acos({expression}).Expression handler to evaluate Math.asin({expression}).Expression handler to evaluate Math.atan({expression}).Expression handler to evaluate Math.ceil({expression}).Expression handler to evaluate Math.cos({expression}).Expression handler to evaluate Math.exp({expression}).Expression handler to evaluate Math.floor({expression}).Expression handler to evaluate Math.log({expression}).Expression handler to evaluate Math.power({expression}).Expression handler to evaluate Math.sin({expression}).Expression handler to evaluate Math.sqrt({expression}).Expression handler to evaluate Math.tan({expression}).Expression handler to evaluate Math.toDegrees({expression}).Expression handler to evaluate Math.toRadians({expression}).Expression handler to invoke the SQL MAX aggregation function.Expression handler to invoke the SQL MIN aggregation function.Expression handler to invoke the SQL NULLIF function.Expression handler to evaluate {objectExpression}.getClass().Method for evaluating {optionalExpr1}.get().Method for evaluating {optionalExpr1}.isPresent().Method for evaluating {optionalExpr1}.orElse().Expression handler to invoke the SQL POWER function.Expression handler to invoke the SQL RADIANS function.Expression handler to evaluate ROUND({expression}[,{decimalPlaces}]).Expression handler to invoke the SQL SIGN function.Expression handler to invoke an SQL aggregated function.Expression handler to invoke an SQL numeric function that takes in argument(s).Expression handler to invoke an SQL aggregated function.Expression handler to invoke an SQL String function that takes in an expression.Expression handler to invoke the SQL SIN function.Expression handler to invoke the SQL SINH function.Method to allow inclusion of any SQL code that returns a boolean.Expression handler to evaluate SQL.cube(args).Method to allow inclusion of any SQL function invocation.Interface to implement to wrap an SQL function.Method to allow inclusion of any SQL code that returns a numeric.Expression handler to evaluate SQL.rollup(args).Expression handler to invoke the SQL SQRT function.Method for evaluating {strExpr}.charAt(numExpr).Method for evaluating {strExpr}.charAt(numExpr).Method for evaluating {strExpr}.concat(strExpr1s).Method for evaluating {strExpr}.concat(strExpr1s).Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]) for Cloud Spanner.Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]).Method for evaluating {strExpr1}.equalsIgnoreCase(strExpr2).Method for evaluating {strExpr1}.equals(strExpr2).Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]) for PostgreSQL.Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).Expression handler to evaluate {stringExpression}.length() with Firebird.Expression handler to evaluate {stringExpression}.length().Expression handler to evaluate {stringExpression}.length().Expression handler to evaluate {stringExpression}.length().Expression handler to evaluate {stringExpression}.matches(StringExpression) for Derby.Expression handler to evaluate {stringExpression}.matches(StringExpression).Method for evaluating {strExpr}.replaceAll(strExpr1, strExpr2).Support for a String.matches like functionality but using Postgresql's "SIMILAR TO" operator.Method for evaluating {strExpr1}.startsWith(strExpr2).Method for evaluating {strExpr1}.startsWith(strExpr2[,numExpr]).Method for evaluating {strExpr1}.startsWith(strExpr2) for cloud spanner.Method for evaluating {strExpr1}.startsWith(strExpr2[, numExpr]).Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).Method for evaluating {strExpr}.substring(numExpr1 [,numExpr2]).Expression handler to invoke the SQL LOWER function.Expression handler to invoke the SQL UPPER function.Method for evaluating {strExpr}.translate(strExpr1, strExpr2).Method for trimming a String expression using LTRIM and RTRIM SQL functions.Method for evaluating {strExpr1}.trim() or "TRIM(BOTH trimChar FROM strExpr1)".Method for evaluating {strExpr1}.trimLeft() or "TRIM(LEADING trimChar FROM strExpr1)".Expression handler to invoke the SQL LTRIM function.Expression handler to invoke the SQL TRIM function.Method for evaluating {strExpr1}.trimLeft() or "TRIM(TRAILING trimChar FROM strExpr1)".Expression handler to invoke the SQL RTRIM function.Expression handler to invoke the SQL SUM aggregation function.Expression handler to invoke the SQL TAN function.Expression handler to invoke the SQL TANH function.Base for all temporal methods.Method for evaluating DAY({dateExpr}).Method for evaluating DAY({dateExpr}) using Oracle.Method for evaluating DAY({dateExpr}) using PostgreSQL.Method for evaluating {dateExpr}.getDay() using SQLite.Method for evaluating {dateExpr}.getDay() for Firebird and CloudSpanner.Method for evaluating DAY_OF_WEEK({dateExpr}) using H2.Method for evaluating DAY_OF_WEEK({dateExpr}) using PostgreSQL.Method for evaluating DAY_OF_WEEK({dateExpr}) using MySQL.Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLServer.Method for evaluating DAY_OF_WEEK({dateExpr}) using SQLite.Method for evaluating DAY_OF_WEEK({dateExpr}) for Firebird.Method for evaluating DAY_OF_WEEK({dateExpr}) for CloudSpanner.Method for evaluating DAYOFYEAR({dateExpr}) for CloudSpanner.Method for evaluating HOUR({dateExpr}).Method for evaluating HOUR({dateExpr}) using Oracle.Method for evaluating HOUR({dateExpr}) using PostgreSQL.Method for evaluating HOUR({dateExpr}) using SQLServer.Method for evaluating HOUR({dateExpr}) using SQLite.Method for evaluating HOUR({dateExpr}) for Firebird and CloudSpanner.Method for evaluating ISOWEEK({dateExpr}) for CloudSpanner.Method for evaluating ISOYEAR({dateExpr}) for CloudSpanner.Method for evaluating MILLISECOND({dateExpr}) for CloudSpanner.Method for evaluating MINUTE({dateExpr}).Method for evaluating MINUTE({dateExpr}) using Oracle.Method for evaluating {dateExpr}.getMinute() using PostgreSQL.Method for evaluating MINUTE({dateExpr}) using SQLServer.Method for evaluating MINUTE({dateExpr}) using SQLite.Method for evaluating MINUTE({dateExpr}) for Firebird and CloudSpanner.Method for evaluating {dateExpr}.getMonth().Method for evaluating {dateExpr}.getMonth().Method for evaluating {dateExpr}.getMonth() using PostgreSQL.Method for evaluating {dateExpr}.getMonth() using SQLite.Method for evaluating {dateExpr}.getMonth() for Firebird and CloudSpanner.Method for evaluating MONTH({dateExpr}).Method for evaluating MONTH({dateExpr}) using Oracle.Method for evaluating MONTH({dateExpr}) using PostgreSQL.Method for evaluating MONTH({dateExpr}) using SQLite.Method for evaluating MONTH({dateExpr}) for Firebird and CloudSpanner.Method for evaluating QUARTER({dateExpr}).Method for evaluating QUARTER({dateExpr}) using Oracle.Method for evaluating QUARTER({dateExpr}) using PostgreSQL.Method for evaluating QUARTER({dateExpr}) using SQLServer.Method for evaluating QUARTER({dateExpr}) for CloudSpanner.Method for evaluating SECOND({dateExpr}).Method for evaluating SECOND({dateExpr}) using Oracle.Method for evaluating SECOND({dateExpr}) using PostgreSQL.Method for evaluating SECOND({dateExpr}) using SQLServer.Method for evaluating SECOND({dateExpr}).Method for evaluating SECOND({dateExpr}) using SQLite.Method for evaluating SECOND({dateExpr}) for Firebird and CloudSpanner.Method for evaluating WEEK({dateExpr}).Method for evaluating WEEK({dateExpr}) using Sybase.Method for evaluating WEEK({dateExpr}) using PostgreSQL.Method for evaluating WEEK({dateExpr}) using SQLServer.Method for evaluating WEEK({dateExpr}) for Firebird and CloudSpanner.Method for evaluating WEEK({dateExpr}) using Oracle.Method for evaluating YEAR({dateExpr}).Method for evaluating YEAR({dateExpr}) using Oracle.Method for evaluating YEAR({dateExpr}).Method for evaluating YEAR({dateExpr}) using SQLite.Method for evaluating YEAR({dateExpr}) for Firebird and CloudSpanner.