ObjectDB Database Search

(Optional) A SQL fragment appended to the generated DDL statement which creates this table

to the generated SQL to create a column of the inferred type. Default: "" Since: Jakarta Persistence (JPA) 1.0

column. Defaults to the provider-generated SQL to create a column of the specified discriminator

and entity relationships. The root must be an entity type. The methods to add subgraphs implicitly create

String options (Optional) A SQL fragment appended to the generated DDL which creates this constraint

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression nullif (    Expression x ,    Y y ) Create an expression that tests whether its argument are equal, returning null if they are and the value of the first expression if they are not

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Coalesce coalesce() Create a coalesce expression. Returns: coalesce expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder SimpleCase selectCase (    Expression expression ) Create a simple case expression. Parameters: expression - to be tested against the case conditions Returns: simple case expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Case selectCase() Create a general case expression. Returns: general case expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaSelect union (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the union of the given queries. Returns: a new criteria query which returns the union

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaSelect unionAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the union of the given queries, without elimination of duplicate results. Returns: a new

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaSelect intersect (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the intersection of the given queries. Returns: a new criteria query which returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaSelect intersectAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the intersection of the given queries, without elimination of duplicate results. Returns

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Class getResultType() Return the result type of the query or subquery. If a result type was specified as an argument to the createQuery or subquery method, that type is returned. If the query was created using

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createQuery() Create a CriteriaQuery object. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createQuery (    Class resultClass ) Create a CriteriaQuery object with the given result type. Parameters: resultClass - type of the query result Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    Class type ) Create a subquery of the query. Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    EntityType type ) Create a subquery of the query. Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CompoundSelection tuple (    Selection ... selections ) Create a tuple-valued selection item. Parameters: selections - selection items Returns: tuple-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CompoundSelection tuple (    List selections ) Create a tuple-valued selection item. Parameters: selections - list of selection items Returns: tuple-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CompoundSelection array (    Selection ... selections ) Create an array-valued selection item. Parameters: selections - selection items Returns: array-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CompoundSelection array (    List selections ) Create an array-valued selection item. Parameters: selections - list of selection items Returns: array-valued compound selection. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createTupleQuery() Create a CriteriaQuery object that returns a tuple of objects as its result. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaUpdate createCriteriaUpdate (    Class targetEntity ) Create a CriteriaUpdate query object to perform a bulk update operation. Parameters: targetEntity - target type for update operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaDelete createCriteriaDelete (    Class targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CompoundSelection construct (    Class resultClass ,    Selection ... selections ) Create a selection item corresponding to a constructor. This method is used to specify a constructor

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression avg (    Expression x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sum (    Expression x ) Create an aggregate expression applying the sum operation. Parameters: x - expression representing input value to sum operation Returns: sum expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result. Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order asc (    Expression expression ) Create an ordering by the ascending value of the expression. Parameters: expression - expression used to define the ordering Returns: ascending ordering corresponding to the expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order desc (    Expression expression ) Create an ordering by the descending value of the expression. Parameters: expression - expression used to define the ordering Returns: descending ordering

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order asc (    Expression expression ,    Nulls nullPrecedence ) Create an ordering by the ascending value of the expression. Parameters: expression - expression used to define the ordering

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Order desc (    Expression expression ,    Nulls nullPrecedence ) Create an ordering by the descending value of the expression. Parameters: expression - expression used to define the ordering

Jakarta Persistence (JPA) Method in jakarta.persistence.UniqueConstraint String options (Optional) A SQL fragment appended to the generated DDL which creates this constraint. Default: "" Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Root from (    Class entityClass ) Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots. Parameters: entityClass - the entity class Returns: query

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Root from (    EntityType entity ) Create and add a query root corresponding to the given entity, forming a cartesian product with any existing roots. Parameters: entity - metamodel entity representing

Jakarta Persistence (JPA) Constructor in jakarta.persistence.PersistenceConfiguration PersistenceConfiguration (    String name ) Create a new empty configuration. An empty configuration does not typically hold enough information for successful invocation of PersistenceConfiguration

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Predicate boolean isNegated() Whether the predicate has been created from another predicate by applying Predicate.not or by calling CriteriaBuilder.not . Returns: boolean indicating if the predicate is a negated predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Predicate Predicate not() Create a negation of the predicate. Returns: negated predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Root correlate (    Root parentRoot ) Create a subquery root correlated to a root of the enclosing query. Parameters: parentRoot - a root of the containing query Returns: subquery root. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Join correlate (    Join parentJoin ) Create a subquery join object correlated to a join object of the enclosing query. Parameters: parentJoin - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery CollectionJoin correlate (    CollectionJoin parentCollection ) Create a subquery collection join object correlated to a collection join object of the enclosing query. Parameters: parentCollection - join object

Jakarta Persistence (JPA) Method in jakarta.persistence.TableGenerator Index[] indexes (Optional) Indexes for the table. These are only used if table generation is in effect. Note that it is not necessary to specify an index for a primary key, as the primary key index is created automatically. Default: {} Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.TableGenerator String options (Optional) A SQL fragment appended to the generated DDL statement which creates this table. Default: "" Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery SetJoin correlate (    SetJoin parentSet ) Create a subquery set join object correlated to a set join object of the enclosing query. Parameters: parentSet - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery ListJoin correlate (    ListJoin parentList ) Create a subquery list join object correlated to a list join object of the enclosing query. Parameters: parentList - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery MapJoin correlate (    MapJoin parentMap ) Create a subquery map join object correlated to a map join object of the enclosing query. Parameters: parentMap - join object of the containing query Returns: subquery join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From MapJoin joinMap (    String attributeName ,    JoinType jt ) Create a join to the specified Map -valued attribute using the given join type. Parameters: attributeName - name of the attribute for the target

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.ListJoin Expression index() Create an expression that corresponds to the index of the object in the referenced association or element collection. This method must only be invoked upon an object that represents an association or