ObjectDB Database Search

Hello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE ( SELECT count(a) FROM l.things a WHERE a.thing.status != :status)

select query for a HashMap field of an entity.

Class fields selection to store

selective update does not work

Selective merge/cascade of detatched entity

we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:   UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and o.state = 0 and o.type = 1 and o.parentNode.classIdentifier

the SELECT clause of a SQL query to an entity result. If this annotation is used, the SQL statement should select all the columns that are mapped to the entity object. This should include foreign key ... . Example: Query q = em.createNativeQuery( " SELECT o.id, o.quantity, o.item, " + "i.id, i.name, i

ConstructorResult annotation to map a column of the SELECT list of a SQL query. The name element references the name of a column in the SELECT list — i.e., column alias, if applicable. Scalar result types ... .createNativeQuery( " SELECT o.id AS order_id, " + "o.quantity AS order_quantity, " + "o.item AS

of TypedQuery for executing a Jakarta Persistence query language named query. The select list of the query ... if there is only one column in the select list.) Column values are returned in the order of their occurrence in the select list and default JDBC type mappings are applied. Parameters: sqlString

of query roots. Since: Jakarta Persistence (JPA) 1.0 Selection getSelection () Return the selection of the query, or null if no selection has been set. Returns: selection item. Since: Jakarta Persistence

multiselect (    List selectionList ) Specify the selection items that are to be returned in the query result. Replaces the previously specified selection (s), if any. The type of the result ... method must not be a tuple- or array-valued compound selection item. The semantics of this method are as

tuple (    List selections ) Create a tuple-valued selection item. Parameters: selections - list of selection items Returns: tuple-valued compound selection . Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item. Since: Jakarta Persistence (JPA) 3.2

array (    List selections ) Create an array-valued selection item. Parameters: selections - list of selection items Returns: array-valued compound selection . Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item. Since: Jakarta Persistence (JPA) 3.2

to map the SELECT clause of a SQL query to a constructor. Applies a constructor for the target class ... is retrieved for the constructed object. Example: Query q = em.createNativeQuery( " SELECT c.id, c.name ... ColumnResult[] columns (Required) The mapping of columns in the SELECT list to the arguments

the SELECT list of a SQL query to the properties or fields of an entity class. Example: Query q = em.createNativeQuery( " SELECT o.id AS order_id, " + "o.quantity AS order_quantity, " + "o.item AS order_item ... column Name of the column in the SELECT clause - i.e., column aliases, if applicable. Since: Jakarta

not to be a Jakarta Persistence query language SELECT query or a CriteriaQuery query. Since: Jakarta ... getResultStream () Execute a SELECT query and return the query results as an untyped java.util.stream.Stream . By ... is found not to be a Jakarta Persistence query language SELECT query or a CriteriaQuery query

= "findWidgets", query = " SELECT o.id, o.quantity, o.item " + "FROM Order o, Item i " + "WHERE (o.item = i.id ... ( name = "OrderItems", query = " SELECT o.id, o.quantity, o.item, i.id, i.name, i.description ... of this annotation: @NamedNativeQuery( name = "OrderItems", query = " SELECT o.id, o.quantity, o.item, i.id, i.name

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Selection getSelection() Return the selection of the query, or null if no selection has been set. Returns: selection item. Since: Jakarta Persistence (JPA) 1.0

. If this annotation is not specified, a default foreign key strategy is selected by the persistence ... .PROVIDER_DEFAULT selects the default behavior of the provider, which may or may not result in

, a default foreign key strategy is selected by the persistence provider. Default: @ForeignKey ... strategy is selected by the persistence provider. Default: @ForeignKey(ConstraintMode.PROVIDER_DEFAULT

, and when the value of the persistence.xml caching element is SharedCacheMode.ENABLE_ SELECTIVE or SharedCacheMode.DISABLE_ SELECTIVE . The value of the Cacheable annotation is inherited by subclasses

_ SELECTIVE Caching is enabled for all entities except those for which Cacheable(false) is specified. Entities ... _ SELECTIVE Caching is enabled for all entities for which Cacheable(true) is specified

p = q.from(Person.class); q. select (p) .where(cb.isMember("joe", p.get("nicknames ... .get("nicknames"); q. select (p) .where(cb.isMember("joe", nicknames)); Parameters: attributeName - name

if there is only one column in the select list.) Column values are returned in the order of their occurrence in the select list and default JDBC type mappings are applied. Parameters: sqlString

. For a primary key of type Long , Integer , long , or int , the provider selects between TABLE

is selected by the persistence provider. Default: @ForeignKey(PROVIDER_DEFAULT) Since: Jakarta

generation is in effect. If this element is not specified, a default foreign key strategy is selected by

is not specified, a default foreign key strategy is selected by the persistence provider. Default

in either location, a default foreign key strategy is selected by the persistence provider. Default

is specified in either location, a default foreign key strategy is selected by the persistence provider

key strategy is selected by the persistence provider. Default: @ForeignKey(ConstraintMode.PROVIDER

is specified in either location, a default foreign key strategy is selected by the persistence

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.SqlResultSetMapping Implemented Interfaces: Annotation Target: Type Specifies a mapping of the columns of a result set of a native SQL query or stored procedure. Example: Query q = em.createNativeQuery( " SELECT o.id AS order_id, " + "o

the Jakarta Persistence query language: @NamedQuery( name = "findAllCustomersWithName", query = " SELECT c

- if the query is found not to be a Jakarta Persistence query language SELECT query or a CriteriaQuery query. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Expression getSelection() Return the selection expression. Returns: the item to be returned in the subquery result. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery Stream getResultStream() Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates to getResultList().stream() , however, persistence provider may choose to override this method

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery X getSingleResult() Execute a SELECT query that returns a single result. Returns: the result, of type X . Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery X getSingleResultOrNull() Execute a SELECT query that returns a single untyped result. Returns: the result, of type X , or null if there is no result. Throws: IllegalStateException - if called for a Jakarta Persistence query

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery List getResultList() Execute a SELECT query and return the query results as a typed List . Returns: a list of the results, each of type X , or an empty list if there are no results. Throws: IllegalStateException - if called

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityResult String discriminatorColumn Specifies the column name (or alias) of the column in the SELECT list that is used to determine the type of the entity instance. Default: "" Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityResult FieldResult[] fields Maps the columns specified in the SELECT list of the query to the properties or fields of the entity class. Default: {} Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.FieldResult String column Name of the column in the SELECT clause - i.e., column aliases, if applicable. Since: Jakarta Persistence (JPA) 1.0

that no constraint should be generated. ConstraintMode.PROVIDER_DEFAULT selects the default behavior

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager TypedQuery createQuery (    String qlString ,    Class resultClass ) Create an instance of TypedQuery for executing a Jakarta Persistence query language statement. The select list of the query must contain

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager TypedQuery createNamedQuery (    String name ,    Class resultClass ) Create an instance of TypedQuery for executing a Jakarta Persistence query language named query. The select list of the query must contain

key of type Long , Integer , long , or int , the provider selects between GenerationType.TABLE

Jakarta Persistence (JPA) Method in jakarta.persistence.MapKeyJoinColumn ForeignKey foreignKey (Optional) Used to specify or control the generation of a foreign key constraint when table generation is in effect. If this element is not specified, a default foreign key strategy is selected by

either location, a default foreign key strategy is selected by the persistence provider. Default

either location, a default foreign key strategy is selected by the persistence provider. Default: @ForeignKey(PROVIDER_DEFAULT) Since: Jakarta Persistence (JPA) 2.1