ObjectDB Database Search

1-50 of 152 results

Index Definition

on more than one persistent field. It is defined by specifying multiple fields in the members attribute of the @Index or @Unique annotations: @Entity @Index ( members ={"lastName","firstName"}) public class ... explicitly in the members attribute, as shown above, the @Index or @Unique annotation can be attached

Collections in JPQL and Criteria Queries

to the number of languages in that collection. [NOT] MEMBER [OF] The [NOT] MEMBER OF operator checks if a specified element is contained in a specified persistent collection field. For example: 'English' MEMBER OF c.languages is TRUE if languages contains 'English' and FALSE if not. 'English' NOT MEMBER OF c

Adding multi part path index on non-embedable object member

Is there a way to add single member index on members of a object member which is not configured embedable but is/are mapped by id like the two members below.  @Entity public class Customer ... ; @Entity @Indices({ @Index( members ={"merchant.name"}), @Index( members ={"stores.name

Possible Bug in MEMBER OF

Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u.users Set user ... for operator MEMBER OF SELECT u FROM Unit u WHERE :user MEMBER OF u. == users

Unique contraint with 2 members

I am trying to do the following: @javax.persistence.Entity public class Account { @Unique() private String name; @Unique( members ={"SalesforceID","sport"}) private String SalesforceID; private String ... ;   @Unique( members ={"SalesforceID","sport"})        

JSON serialization and __odbHidden members

. Thanks. tester15 John The ObjectDB Enhancer adds members to enhanced entity classes ... to these added members . Will it solve the situation that you are currently facing? support Support Yes

@Unique member combination not working

Why does the below code not enforce unique restrictions?   Person @Entity @Unique( members = {"name", "surname"}) public class Person implements Serializable {     @Id    ... ( members = {"name", "surname"})     public static class Person implements Serializable

removing members in existing databases

Hi team i might ask for the best practice to remove some members (i.e. collections) in existing databases. There are several aproaches and I'm not shure wich on is best. 1. Just make the list empty ... a very suitable amount of time. I checked in explorer and the unused members are gone

Query with MEMBER OF on hash map values

Hello, we want to execute following query: SELECT tc FROM TC tc WHERE ?1 MEMBER OF tc.testMacros.values() But we get an internal ObjectDB exception. It is possible to implement a query for this case at all?   @Entity public class TC { @OneToMany Map testMacros = new HashMap(); }   btc_es

member visiting in jpql

member visiting in jpql

Persisting collection where members are subclasses

Persisting collection where members are subclasses

GROUP BY and HAVING clauses

that currency: SELECT c.currency, SUM(c.population) FROM Country c WHERE 'Europe' MEMBER OF c.continents ... WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) 1 The HAVING clause stands as ... ), AVG(c.population) FROM Country c WHERE 'English' MEMBER OF c.languages All the Country objects

FROM clause (JPQL / Criteria API)

WHERE c2 MEMBER OF c1.neighbors Multiple variables are equivalent to nested loops in a program ... , HAVING, IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER , MIN

Logical Operators in JPQL and Criteria API

: Predicate p1 = cb. and (isInUN, isInEU); // Member of both UN and EU Predicate p2 = cb. or (isInOECD, isLarge); // Either OECD member or large Additional factory methods are available for a variant number

JPA Metamodel API

representation of the field (or property) type: Member member = attr. getJavaMember

JPA Query Expressions (JPQL / Criteria)

, [NOT] MEMBER [OF] and the [NOT] LIKE operator. Logical operators : AND, OR, NOT. In addition, JPA

ORDER BY clause (JPQL / Criteria API)

.currency, SUM(c.population) FROM Country c WHERE 'Europe' MEMBER OF c.continents GROUP BY c

jakarta.persistence.criteria.CriteriaBuilder

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 ... ) Create a predicate that tests whether an element is a member of a collection. If the collection

jakarta.persistence.criteria.PluralJoin

Predicate in ( Object... values ) Create a predicate to test whether the expression is a member ... ... values ) Create a predicate to test whether the expression is a member of the argument list. Inherited ... a predicate to test whether the expression is a member of the collection. Inherited from Expression

jakarta.persistence.criteria.Path

a predicate to test whether the expression is a member of the argument list. Inherited from Expression ... whether the expression is a member of the argument list. Inherited from Expression Parameters: values ... is a member of the collection. Inherited from Expression Parameters: values - collection of values

jakarta.persistence.criteria.Predicate

whether the expression is a member of the argument list. Inherited from Expression Parameters: values - values ... in ( Expression ... values ) Create a predicate to test whether the expression is a member ... values ) Create a predicate to test whether the expression is a member of the collection. Inherited

jakarta.persistence.criteria.MapJoin

whether the expression is a member of the argument list. Inherited from Expression Parameters: values ... is a member of the argument list. Inherited from Expression Parameters: values - expressions ... Predicate in ( Collection values ) Create a predicate to test whether the expression is a member

jakarta.persistence.criteria.ParameterExpression

) Create a predicate to test whether the expression is a member of the argument list. Inherited from ... to test whether the expression is a member of the argument list. Inherited from Expression Parameters ... whether the expression is a member of the collection. Inherited from Expression Parameters: values - collection

jakarta.persistence.criteria.Root

is a member of the argument list. Inherited from Expression Parameters: values - values to be tested ... in ( Expression ... values ) Create a predicate to test whether the expression is a member ... values ) Create a predicate to test whether the expression is a member of the collection. Inherited

jakarta.persistence.criteria.Subquery

( Object... values ) Create a predicate to test whether the expression is a member of the argument list ... ) Create a predicate to test whether the expression is a member of the argument list. Inherited from ... to test whether the expression is a member of the collection. Inherited from Expression Parameters: values

jakarta.persistence.criteria.SetJoin

to test whether the expression is a member of the argument list. Inherited from Expression Parameters ... whether the expression is a member of the argument list. Inherited from Expression Parameters: values - expressions ... Predicate in ( Collection values ) Create a predicate to test whether the expression is a member

jakarta.persistence.criteria.CriteriaBuilder.Case

whether the expression is a member of the argument list. Inherited from Expression Parameters: values - values ... Predicate in ( Expression ... values ) Create a predicate to test whether the expression is a member ... ( Collection values ) Create a predicate to test whether the expression is a member of the collection

jakarta.persistence.criteria.CriteriaBuilder.In

... values ) Create a predicate to test whether the expression is a member of the argument list. Inherited ... a predicate to test whether the expression is a member of the argument list. Inherited from Expression ... whether the expression is a member of the collection. Inherited from Expression Parameters: values - collection

jakarta.persistence.criteria.CriteriaBuilder.Coalesce

whether the expression is a member of the argument list. Inherited from Expression Parameters: values - values ... Predicate in ( Expression ... values ) Create a predicate to test whether the expression is a member ... ( Collection values ) Create a predicate to test whether the expression is a member of the collection

jakarta.persistence.criteria.CollectionJoin

in ( Object... values ) Create a predicate to test whether the expression is a member ... ) Create a predicate to test whether the expression is a member of the argument list. Inherited from ... to test whether the expression is a member of the collection. Inherited from Expression Parameters

jakarta.persistence.criteria.Expression

) Create a predicate to test whether the expression is a member of the argument list. Parameters: values ... is a member of the argument list. Parameters: values - expressions to be tested against Returns ... ) Create a predicate to test whether the expression is a member of the collection. Parameters

jakarta.persistence.criteria.CriteriaBuilder.SimpleCase

... values ) Create a predicate to test whether the expression is a member of the argument list ... a predicate to test whether the expression is a member of the argument list. Inherited from Expression ... whether the expression is a member of the collection. Inherited from Expression Parameters: values

jakarta.persistence.criteria.ListJoin

to test whether the expression is a member of the argument list. Inherited from Expression ... whether the expression is a member of the argument list. Inherited from Expression Parameters: values ... ) 1.0 Predicate in ( Collection values ) Create a predicate to test whether the expression is a member

jakarta.persistence.criteria.From

whether the expression is a member of the argument list. Inherited from Expression Parameters: values - values ... Predicate in ( Expression ... values ) Create a predicate to test whether the expression is a member ... ( Collection values ) Create a predicate to test whether the expression is a member of the collection

jakarta.persistence.criteria.Join

... values ) Create a predicate to test whether the expression is a member of the argument list. Inherited ... to test whether the expression is a member of the argument list. Inherited from Expression ... whether the expression is a member of the collection. Inherited from Expression Parameters: values - collection

Multiple MEMBER OF query

that have one label: SELECT i FROM Item i WHERE :label MEMBER OF item.labels I can select items with any of several labels: SELECT i FROM Item i WHERE :label1 MEMBER OF item.labels OR :label2 MEMBER ... gets no items: SELECT i FROM Item i WHERE :label1 MEMBER OF item.labels AND :label2 MEMBER OF item

jakarta.persistence.metamodel.Attribute

. Returns: declaring type. Since: Jakarta Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Returns: corresponding Member . Since: Jakarta Persistence (JPA

jakarta.persistence.metamodel.ListAttribute

PluralAttribute Returns: element type. Since: Jakarta Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member

jakarta.persistence.metamodel.CollectionAttribute

Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member . Since: Jakarta Persistence (JPA) 1.0 Class getJavaType () Return

jakarta.persistence.metamodel.SetAttribute

PluralAttribute Returns: element type. Since: Jakarta Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member

jakarta.persistence.metamodel.SingularAttribute

. Since: Jakarta Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member . Since: Jakarta Persistence (JPA) 1

jakarta.persistence.metamodel.MapAttribute

Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member . Since: Jakarta Persistence (JPA) 1.0 Class getJavaType

jakarta.persistence.metamodel.PluralAttribute

: element type. Since: Jakarta Persistence (JPA) 1.0 Member getJavaMember () Return the Member for the represented attribute. Inherited from Attribute Returns: corresponding Member . Since: Jakarta

InternalException when using MEMBER OF on a large list in a query

Hello, we get when executing a query with MEMBER OF on a large list the following ... " + propertyClassName + " AS property, " + recordClassName + " AS record " + "WHERE property.uid MEMBER OF record.properties AND property.scopeID MEMBER OF ?1"; TypedQuery q = em.createQuery(query, String.class); q

jakarta.persistence.EnumType

/ordinal() member . Since: Jakarta Persistence (JPA) 1.0 STRING Persist enumerated type property or ... of its Enum.java.lang.Enum/name() member . Since: Jakarta Persistence (JPA) 1.0 Synthetic Public Static

jakarta.persistence.metamodel.Attribute.getJavaMember()

Jakarta Persistence (JPA) Method in jakarta.persistence.metamodel.Attribute Member getJavaMember() Return the Member for the represented attribute. Returns: corresponding Member . Since: Jakarta Persistence (JPA) 1.0

jakarta.persistence.criteria.CriteriaBuilder.isMember(Expression,Expression)

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

jakarta.persistence.criteria.CriteriaBuilder.isMember(E,Expression)

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

jakarta.persistence.criteria.CriteriaBuilder.isNotMember(Expression,Expression)

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

jakarta.persistence.criteria.CriteriaBuilder.isNotMember(E,Expression)

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