ObjectDB Database Search

;colletions are to be lazy fetched. You can try this in a query.  "select n from Node n left outer join fetch n.children where ....." this will also fetch your collection. Basically you can use

Hi! Explorer says "unexpected token" on KEY(..: SELECT FROM individual.IndividualContact $1 LEFT OUTER JOIN $1.profile.title.name m WHERE (KEY(m) = 'deu' AND VALUE(m) LIKE '%Dr%') profile = embedded entity title = referenced entity name = Map   thanks, Alex quasado Alexander Adam Yes

; + " left join s.location as s_location "            ... ; + " left join s.location as s_location "            ... ;  + " left join s.location as s_location "          

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From MapJoin joinMap (    String attributeName ) Create an inner join to the specified Map -valued attribute. Parameters: attributeName - name of the attribute for the target of the join Returns: the resulting join . Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Fetch JoinType getJoinType() Return the join type used in the fetch join . Returns: join type. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.FetchParent Set getFetches() Return the fetch joins that have been made from this type. Returns empty set if no fetch joins have been made from this type. Modifications to the set do not affect the query. Returns: fetch joins made from this type. Since: Jakarta Persistence (JPA) 1.0

of the entity. The default only applies if a single join column is used. The default is the same as ... of the referenced primary key column.) However, if there is more than one join column, a JoinColumn annotation must be specified for each join column using the JoinColumns annotation. In this case

API may need to specify the type of the select item when it results from a get or join operation ... = cb.createQuery(Product.class); q2.select(q2.from(Order.class) . join ("items") . join ("product

LEFT OUTER JOIN . Fixed GROUP BY DATE(...) - merging AM and PM into the same date.

Fixed a critical bug in extensive removal operations of large objects. Improved the performance of navigation through an inverse (mapped by) field if the owner field is indexed. Fixed a LEFT OUTER JOIN bug . Fixed a bug in parsing queries with parenthesis followed by NOT . Fixed a bug in running

Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s  WHERE a.startStep.stepNumber = 0  AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result objects

Hello, we have an issue with following query which needs with objectdb-2.7.6_07 only 15 - 30 milli seconds, but since objectdb-2.7.6_08 the query needs round about 3000 ms. I added a database example in a ticket. SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s WHERE a.endStep.stepNumber = 2000 AND a.startStep.stepNumber

Improved query plan evaluation (including for selecting composite indexes). Fixed new statistics collection for queries. Fixed a bug in LEFT OUTER JOIN queries ( issue #2438 ).

(for LEFT OUTER JOIN ). [Step 4] Merge the results of steps 2, 3 using OR. [Step 5] Apply selection

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder SetJoin treat (    SetJoin join ,    Class type ) Downcast SetJoin object to the specified type. Parameters: join - SetJoin object type - type to be downcast to Returns: SetJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder ListJoin treat (    ListJoin join ,    Class type ) Downcast ListJoin object to the specified type. Parameters: join - ListJoin object type - type to be downcast to Returns: ListJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder MapJoin treat (    MapJoin join ,    Class type ) Downcast MapJoin object to the specified type. Parameters: join - MapJoin object type - type to be downcast to Returns: MapJoin object of the specified type. Since: Jakarta Persistence (JPA) 2.1

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.PluralJoin PluralAttribute getModel() Return the metamodel representation for the collection-valued attribute corresponding to the join . Returns: metamodel collection-valued attribute corresponding to the target of the join . Since: Jakarta Persistence (JPA) 1.0

. If a joined inheritance strategy is used, or if the entity is otherwise mapped to a secondary table ... to join tables or unidirectional one-to-many relationships for which the target entity contains

and relationships owned by the entity that are contained in join tables are locked if the property ... ). Locking such a relationship or element collection generally locks only the rows in the join table

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager boolean isJoinedToTransaction() Determine whether the entity manager is joined to the current transaction. Returns false if the entity manager is not joined to the current transaction or if no transaction is active. Returns: boolean. Since: Jakarta Persistence (JPA) 2.1

. If the map key is for a ManyToMany entity relationship or for a OneToMany entity relationship using a join table, the map key column is in a join table. If the map key is for a OneToMany entity relationship

entity relationship using a join table, the name of the join table for the map. If the map key

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Fetch Attribute getAttribute() Return the metamodel attribute corresponding to the fetch join . Returns: metamodel attribute for the join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.PrimaryKeyJoinColumn String referencedColumnName (Optional) The name of the primary key column of the table being joined to. Defaults to the same name as the primary key column of the primary table of the superclass ( JOINED mapping strategy

Jakarta Persistence (JPA) Method in jakarta.persistence.AssociationOverride JoinColumn[] joinColumns The join column(s) being mapped to the persistent attribute(s). The joinColumns elements ... . The joinColumns element must not be specified if a join table is used in the overriding of the mapping

Jakarta Persistence (JPA) Method in jakarta.persistence.AssociationOverride JoinTable joinTable The join table that maps the relationship. The joinTable element must be specified if a join table is used in the overriding of the mapping of the relationship. The joinTable element must not

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CollectionJoin treat (    CollectionJoin join ,    Class type ) Downcast CollectionJoin object to the specified type. Parameters: join - CollectionJoin object type - type to be downcast to Returns

is unspecified. If there is no transaction active or the persistence context is not joined to the current

is used. Example: @Entity @Inheritance(strategy = JOINED ) public class Customer { ... } @Entity public

Persistence (JPA) 1.0 Annotation Elements JoinColumn[] value The join columns that map the relationship

annotation. Alternatively, an optional OneToOne association is sometimes mapped to a join table

(JPA) 2.0 Annotation Elements MapKeyJoinColumn[] value (Required) The map key join columns

the associated entity , and a many-to-many association usually maps to a join table . Every entity

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.DiscriminatorColumn Implemented Interfaces: Annotation Target: Type Specifies the discriminator column for the SINGLE_TABLE and JOINED inheritance mapping strategies . The mapping strategy and discriminator column are only specified

and the persistence context has been joined to it, will be marked for rollback. See Also: EntityManager

, if one is active and the persistence context has been joined to it, will be marked for rollback

own joins ). All queries may have: a conjunction of restrictions. Since: Jakarta Persistence (JPA) 2.0

and the persistence context joined to the transaction. Default: LockModeType.NONE Since: Jakarta Persistence (JPA) 2

to a join table using the JoinTable annotation. The OneToOne annotation may be used within an embeddable

, if one is active and if the persistence context has been joined to it, to be marked for rollback

whether the persistence context must be explicitly joined to the current transaction by means of the EntityManager

Hi, Assuming those queries which are all the same except the UPPER calls: # Case (1) SELECT COUNT($1) FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $1.profile $3 LEFT JOIN $3.organisation $4 LEFT JOIN $1.postalAddresses $5 LEFT JOIN $1

application startup & shutdown cycles. Each cycle of the outer loop should create 10 writer threads (5 ... ) if I enable another 5 threads to read from test1 and write to test2 - I've left this commented ... it looked ok but when I bumped up the msg size to 5mb and left it running for 25mins I got

instanceEntryArtifactSet , com.btc.ep.engine.bl.internal.dmos.ArtifactImpl AS artifact LEFT JOIN artifact.activatedGoals AS artifactActivatedGoals LEFT JOIN artifact.activatedAssumptions AS artifactActivatedAssumptions LEFT JOIN artifact.activatedCalibrations AS artifactActivatedCalibrations

Jakarta Persistence (JPA) Method in jakarta.persistence.PersistenceContext SynchronizationType synchronization (Optional) Specifies whether the persistence context is always automatically synchronized with the current transaction or whether the persistence context must be explicitly joined

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CollectionJoin CollectionAttribute getModel() Return the metamodel representation for the collection attribute. Returns: metamodel type representing the Collection that is the target of the join . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.SetJoin SetAttribute getModel() Return the metamodel representation for the set attribute. Returns: metamodel type representing the Set that is the target of the join . Since: Jakarta Persistence (JPA) 1.0

other than NONE has been set and there is no transaction or the persistence context has not been joined

and there is no transaction or the persistence context has not been joined to the transaction. Since: Jakarta Persistence (JPA) 1.0