ObjectDB Database Search

to my inquiry a few months ago. However, I have run into one problem: if an embedded collection is empty, but I attempt to LEFT JOIN FETCH all the members of a collection within a (non-existent) member of the first collection , the result of the overall query is an empty set. To use the example from

Greetings ObjectDB team, Suppose I have a collection typed field (list/map/set...) in my  ... handling such expressions. Indexes are supported in handling more conventional  collection ... supported in queries, and anyway, collections are preferred over arrays when using JPA/JDO (and they might be even more efficient). support Support

Hello, is there any chance that you support composite indices with fields and collections combined in the future? We need such feature in our application and would be very happy to see it in ... (probably with a restriction of one collection ). support Support Hello, yes, one collection

I have an entity that contains a java collection of a Long id of user entities that can modify ... could do something besides a java collection if there is a better approach. SailBlue5 Michael Herman You can define an index on a collection field as explained in the manual , and the index

Hi, thanks very much for your helpful software. The problem is the storage of  collection or ... is we confirm that the collection or map are stored successfully by using explorer tools when the JVM ... () of collection or map before closing the EntityManager, data can be retrieved successfully: 

It is possible to execute a query over a keySet of a map field with comparing to a collection parameter? Set values = new HashSet (); values.add("c2"); String query = // "SELECT e " + "FROM ... with a parameter which is a collection of strings. SELECT e FROM EntityParent e JOIN e . map key

I have an OrderData class, containing an OrderItemData collection , i would like to find OrderData elements by OrderData.items.itemId. I cant get a proper query with MEMBER OF or IN. Does ... addition, replace the ordinary array with a collection (e.g. ArrayList ). You may also need to use

Hello, I need to evaluate a field ("identifier") which is situated in a collection , within an entity. As stated in the documentation it is not possible to navigate there with the dot operator since its a collection . Is it there a way to evaluate this field? Here is the query, the entity

Given that the default seems to be FetchType.LAZY for all collections @OneToMany and @ManyToMany. Such as a configuration option. Instead of having to explicitly set fetch in annotation code in every relationship. webel Dr Darren Kelly No. There is no such configuration option, since having EAGER

Hi, i started to use ObjectDB today and i'm having problem using command  Collections .sort in persisted object.  Attempt to modify an object with no active transaction when NontransactionalWrite is disabled: br.ufpa.linc.MetriX.api.model.Interface#105 (error 635)   I don't want

Hi,   I'm having a hard time narrowing down an issue that only became apparent with in the UI. The issue is that, I'm getting repeated results of the owning entity of an '@ElementCollection'. The entity returned is repeated for every element in the collection . Switching back to EclipseLink

on a collection , but I'm not sure if that will alter my program state.  Will it? Thanks, Lee 

persistence capable classes). Support of map values which are collections is non standard

How to apply constraints like unique, not null ...etc in collection attribute of a entity. Example : @Entity @Table(name = "agent") public class Agent implements Serializable { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Long Id; private List PhoneNumbers; public Agent() { } public

Persisting collection where members are subclasses

how to persist an object twice into two diff. collections of two diff. classes

How to move @Embedable collection to a dedicated entity class?

As discussed and demonstrated in this forum thread , collection operators and methods (IS EMPTY, SIZE, MEMBER OF, IN) are currently not supported for mapped by (inverse) collections . These operations are supported for direct (not mapped by) collections . Navigation and JOIN is supported

Hello! When the JPA entities are not enhanced the removal of an entry from a @OneToMany collection ... you for this report. It represents an issue with non enhanced classes, but it is not related to @OneToMany collection ... . support Support Hello, I have tried version 2.6.0_04. The problem with the @OneToMany collection

use JPA criteria query API, and I pass an empty collection to IN expression: CriteriaBuilder cb

accidently we used the option delete on a collection of type ArrayList . On doing so the type changed to List . we are using explorer version 2.7.1_02 How can we change that back again ? hgzwicker Hans-Georg Zwicker Is it only an issue with the type of the field as shown by the Explorer or

ObjectDB version 2.5.5 (and above) supports Java 8 (JDK 1.8). Tracking changes to collections and maps using some new Java 8 methods is currently not fully supported. The main known issue is that orphan removal does not happen as a result of removing a reference to an object

After using the enhancer, Lazy loaded collections are no longer loading. They are set as null

Objects are not garbage collected

. Since: Jakarta Persistence (JPA) 1.0 boolean isCollection () Is the attribute collection -valued (represents a Collection , Set , List , or Map ). Returns: boolean indicating whether the attribute is collection -valued. Since: Jakarta Persistence (JPA) 1.0

() Is the attribute collection -valued (represents a Collection , Set , List , or Map ). Inherited from Attribute Returns: boolean indicating whether the attribute is collection -valued. Since: Jakarta

annotation is specified on a OneToMany or ManyToMany relationship or on an element collection . The OrderColumn annotation is specified on the side of the relationship that references the collection ... ) ordering of the values of the order column when updating the association or element collection . The order

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Path Expression get (    PluralAttribute collection ) Create a path corresponding to the referenced collection -valued attribute. Parameters: collection - collection -valued attribute Returns: expression corresponding to the referenced attribute. Since: Jakarta Persistence (JPA) 1.0

addition to the locking behavior specified for PessimisticLockScope.NORMAL , element collections ... ). Locking such a relationship or element collection generally locks only the rows in the join table or collection table for that relationship or collection . This means that phantoms are possible. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression size (    C collection ) Create an expression that tests the size of a collection . Parameters: collection - collection Returns: size expression. Since: Jakarta Persistence (JPA) 1.0

isMember (    Expression elem ,    Expression collection ) Create a predicate that tests whether an element is a member of a collection . If the collection is empty, the predicate will be false. Parameters: elem - element expression collection - expression Returns: is-member predicate. Since: Jakarta Persistence (JPA) 1.0

isMember (    E elem ,    Expression collection ) Create a predicate that tests whether an element is a member of a collection . If the collection is empty, the predicate will be false. Parameters: elem - element collection - expression Returns: is-member predicate. Since: Jakarta Persistence (JPA) 1.0

isNotMember (    Expression elem ,    Expression collection ) Create a predicate that tests whether an element is not a member of a collection . If the collection is empty, the predicate will be true. Parameters: elem - element expression collection - expression Returns: is-not-member predicate. Since: Jakarta Persistence (JPA) 1.0

isNotMember (    E elem ,    Expression collection ) Create a predicate that tests whether an element is not a member of a collection . If the collection is empty, the predicate will be true. Parameters: elem - element collection - expression Returns: is-not-member predicate. Since: Jakarta Persistence (JPA) 1.0

for an element collection , the foreign key column is in the collection table for the map value. If the join ... of the entity that is the value of the map. Default: If the map is for an element collection , the name of the collection table for the map value. If the map is for a OneToMany or ManyToMany entity

, an element collection usually maps to a separate collection table , a many-to-one association usually maps

Persistence (JPA) 1.0 ELEMENT_ COLLECTION Element collection Since: Jakarta Persistence (JPA) 1.0 EMBEDDED

, Serializable Since: Jakarta Persistence (JPA) 1.0 Enum Constants COLLECTION Collection -valued attribute

attribute ) Create a fetch join to the specified collection -valued attribute using an inner join ... join to the specified collection -valued attribute using the given join type. Inherited from

Fetch fetch ( PluralAttribute attribute ) Create a fetch join to the specified collection -valued ... a fetch join to the specified collection -valued attribute using the given join type. Parameters: jt

). May be applied to an element collection containing instances of an embeddable class or to a map collection whose key and/or value is an embeddable class. When AttributeOverride is applied to a map

Jakarta Persistence (JPA) Method in jakarta.persistence.metamodel.Attribute boolean isCollection() Is the attribute collection -valued (represents a Collection , Set , List , or Map ). Returns: boolean indicating whether the attribute is collection -valued. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression size (    Expression collection ) Create an expression that tests the size of a collection . Parameters: collection - expression Returns: size expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isEmpty (    Expression collection ) Create a predicate that tests whether a collection is empty. Parameters: collection - expression Returns: is-empty predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Predicate isNotEmpty (    Expression collection ) Create a predicate that tests whether a collection is not empty. Parameters: collection - expression Returns: is-not-empty predicate. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From CollectionJoin join (    CollectionAttribute collection ) Create an inner join to the specified Collection -valued attribute. Parameters: collection - target of the join Returns: the resulting join. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.From CollectionJoin join (    CollectionAttribute collection ,    JoinType jt ) Create a join to the specified Collection -valued attribute using the given join type. Parameters: jt - join type collection - target

() (Optional) The basic or embeddable class that is the element type of the collection . This element is optional only if the collection field or property is defined using Java generics, and must be specified otherwise. It defaults to the parameterized type of the collection when defined using generics. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.metamodel.ManagedType Set getPluralAttributes() Return all multi-valued attributes ( Collection -, Set-, List-, and Map-valued attributes ... : Collection -, Set-, List-, and Map-valued attributes. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.metamodel.ManagedType Set getDeclaredPluralAttributes() Return all multi-valued attributes ( Collection -, Set-, List-, and Map-valued ... attributes. Returns: declared Collection -, Set-, List-, and Map-valued attributes. Since: Jakarta Persistence (JPA) 1.0