Package org.eclipse.persistence.queries

Class StoredFunctionCall

  • All Implemented Interfaces:
    Serializable, Cloneable, Call
    public class StoredFunctionCall
extends StoredProcedureCall
    Purpose: Used to define a platform independent function call. Note that not all platforms support stored functions. This supports output parameters. Functions can also be called through custom SQL.
    See Also:
    Serialized Form

    • Constructor Detail

      • StoredFunctionCall

        public StoredFunctionCall()

      • StoredFunctionCall

        public StoredFunctionCall​(int sqlType,
                          String sqlTypeName,
                          Class javaType)

      • StoredFunctionCall

        public StoredFunctionCall​(int sqlType,
                          String sqlTypeName,
                          Class javaType,
                          DatabaseField nestedType)

      • StoredFunctionCall

        public StoredFunctionCall​(int sqlType,
                          String sqlTypeName,
                          String javaTypeClassName)

      • StoredFunctionCall

        public StoredFunctionCall​(int sqlType,
                          String sqlTypeName,
                          String javaTypeClassName,
                          DatabaseField nestedType)

    • Method Detail

      • setResult

        public void setResult​(String name)
        PUBLIC: Define the field name to be substitute for the function return.

      • setResult

        public void setResult​(String name,
                      Class type)
        PUBLIC: Define the field name to be substitute for the function return. The type is the type of Java class desired back from the function, this is dependent on the type returned from the function.

      • setResult

        public void setResult​(String name,
                      int type,
                      String typeName)
        PUBLIC: Define the field name to be substitute for the function return. The type is the type of Java class desired back from the function, this is dependent on the type returned from the function.

      • setResult

        public void setResult​(int type,
                      String typeName,
                      Class javaType)
        PUBLIC: Define the ObjectRelationalDatabaseField to be substituted for the function return. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types. The javaType is the mapped Class that has an ObjectRelationalDataTypeDescriptor for the ARRAY or STRUCT type typeName

      • setResult

        public void setResult​(int type,
                      String typeName,
                      Class javaType,
                      DatabaseField nestedType)
        PUBLIC: Define the ObjectRelationalDatabaseField to be substituted for the function return. This will typically be called for ARRAY types. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY types. The javaType is the mapped Class that has an ObjectRelationalDataTypeDescriptor for the ARRAY type typeName The nestedType is a database field representing the type the ARRAY holds onto.

      • setResult

        public void setResult​(String name,
                      int type)
        PUBLIC: Define the field name to be substitute for the function return. The type is the type of Java class desired back from the function, this is dependent on the type returned from the function.

      • setResultCursor

        public void setResultCursor()
        PUBLIC: Define to return cursor as result.