Package org.datanucleus.store.rdbms.sql.method

Support for invocation of Java methods, typically using SQL functions.

See:
          Description

Interface Summary
SQLMethod Interface to implement to wrap an SQL function.
 

Class Summary
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.
CeilFunction Expression handler to invoke the SQL CEIL function.
CollectionContainsMethod Method for evaluating {collExpr1}.contains().
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.
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.
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.
DateGetMinuteMethod Method for evaluating {dateExpr}.getMinute().
DateGetMonth2Method Method for evaluating {dateExpr}.getMonth().
DateGetMonth3Method Method for evaluating {dateExpr}.getMonth() using PostgreSQL.
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 MSSQL.
DateGetSecondMethod Method for evaluating {dateExpr}.getSecond().
DateGetYear2Method Method for evaluating {dateExpr}.getYear().
DateGetYear3Method Method for evaluating {dateExpr}.getYear().
DateGetYearMethod Method for evaluating {dateExpr}.getYear().
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}).
LogFunction Expression handler to invoke the SQL 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 {mapExpr1}.get().
MapIsEmptyMethod Method for evaluating {mapExpr}.isEmpty().
MapSizeMethod Method for evaluating {mapExpr}.size().
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}).
MaxFunction Expression handler to invoke the SQL MAX aggregation function.
MinFunction Expression handler to invoke the SQL MIN aggregation function.
SimpleAggregateMethod Expression handler to invoke an SQL aggregated function.
SimpleNumericMethod Expression handler to invoke an SQL numeric function that takes in argument(s).
SimpleStringMethod Expression handler to invoke an SQL String function that takes in an expression.
SinFunction Expression handler to invoke the SQL SIN function.
SQLCubeFunction Expression handler to evaluate SQL.cube(args).
SQLRollupFunction Expression handler to evaluate SQL.rollup(args).
SqrtFunction Expression handler to invoke the SQL SQRT function.
StringCharAtMethod Method for evaluating {strExpr}.charAt(numExpr).
StringEndsWithMethod Method for evaluating {strExpr1}.endsWith(strExpr2[, numExpr]).
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]).
StringIndexOfMethod Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]).
StringLength2Method Expression handler to evaluate {stringExpression}.length().
StringLength3Method Expression handler to evaluate {stringExpression}.length().
StringLengthMethod Expression handler to evaluate {stringExpression}.length().
StringMatches2Method Expression handler to evaluate {stringExpression}.matches(StringExpression).
StringMatchesMethod Expression handler to evaluate {stringExpression}.matches(StringExpression).
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]).
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.
StringTrim2Method Method for trimming a String expression using LTRIM and RTRIM SQL functions.
StringTrimLeftMethod Expression handler to invoke the SQL LTRIM function.
StringTrimMethod Expression handler to invoke the SQL TRIM function.
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.
 

Package org.datanucleus.store.rdbms.sql.method Description

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 © 2009. All Rights Reserved.