ObjectDB Database Search

is also a Date member like r.startDateTime.   prolancer Emil Andonov As I was writing the previous ... the problem if a run a query where the ORDER BY filed is not a member of any index. It just happens that startDateTime is not a member of any index while startDate, callDirection and mapToCli are members

if we order by a simple member (e.g. a String) being the Entity-ID and, at the same time, filter on this member with a simple IN-clause. Filtering with IN-clause or ordering on another member (which is not ... both are done on the ID member .   Assuming this simple Entity class: @Entity public class Location

Hi, I have the following entity class: @Entity @Table @Indices({ @Index( members ={"relationshipType", "party"}), @Index( members ={"relationshipType", "otherParty"}), @Index( members ={"relationshipType ... RelationshipType { PARENT, OWNER, ADMIN, CONTAINS, MEMBER , EMPLOYEE, MANAGER } private BaseObject party

- and the MEMBER OF operator doesn't seem to do what I want (although I may be using it incorrectly ... is in subqueries). The following code demonstrates how to use MEMBER OF with parameter for this purpose ... ;     "SELECT e.name FROM MyEntity e WHERE e.name MEMBER OF :names");   

" + EntityParent.class.getName() + " e " + "WHERE e.map member of ?1"; TypedQuery q = em.createQuery(query ... .value member of ?1 support Support I know this solution and this would also be also my first solution ... WHERE key member of ?1 Set params = new HashSet ( ) ; params . add ( "c2" ) ; q . setParameter ( 1 , params

we defined a composite index for class Action: @Index(name="ssst", members ={"startDate","state ... the composite index: @Index(name="ssst", members ={"state","subType","type", "startDate"}) or any ... less useful, unless  startDate is last. support Support the sequence of the index members is the key, thanks hgzwicker Hans-Georg Zwicker

A . Something like: @Entity @Unique( members ={"b.c.values"}) @Entity public class A {     private B b ... . but my requirement is something like this @Entity @Unique( members = { "b1.c.values", "b2.c.values ... These are my sample classes. @Entity @Unique( members = { "b1.c.values", "b2.c.values" }) public class

back. Here are the relevant parts of the involved Entity classes: @Entity @Indices({     @Index( members = {"lastPosition.receiveTime"}),     @Index( members = {"lastMovingPosition.receiveTime ... ;    return channelConfigurationSets;     } ... } @Entity @Index( members

WHERE si.term MEMBER OF :terms",     Page.class); query.setParameter("terms", terms ... = em.createQuery( "SELECT DISTINCT p FROM Page p " + "WHERE :t1 MEMBER OF p.terms AND :t2 MEMBER OF p

I'm trying to work out the most efficient way to build a query that can compare two collections for identical members . Something like: SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER ... . This is easier and supported by JPA: SELECT o FROM MyClass o JOIN o.someCollection e WHERE e MEMBER

( members ={"tStamp.value", "instrumentId"}) public class OBN implements Serializable{     ... index definition is invalid: @Entity @Index( members ={"lastName", "address.city"}) // INVALID public ... ;  @Entity     @Index( members ={"tStamp.value", "instrumentId"})    

none of these indices is in the log:   @Indices({  @Index(name="ctso", members ={"classIdentifier","type","state","objectNameUpper"}), @Index(name="lctso", members ={"linkedObjects.classIdentifier","linkedObjects.type","linkedObjects.state","linkedObjects.objectNameUpper"}), @Index(name="ln", members

First of all, thank you for promptly implementing JOIN FETCH over nested paths in response 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

the  Symbol class, which has a private non-static member named string but a few static members

;  I have a domain object class Called Department, which has a member of type DomainId.  DomainId has two member fields:  String accountId and String objectId.  The following code

_08 which fixes an issue of using MEMBER with embedded objects. support Support great, it works ... has different members , but the same size.  List uid1_list = .. new Testclass(1,1), new Testclass(2,1

attributeList = new ArrayList (); } @Entity @Unique( members ={"type","value"}) class Attribute {   ... enum (more efficient). An alternative solution is to use embedded objects: @Entity @Index( members

Hi, we are evaluating ObjectDB 2.5.1_03 in embedded mode. We have a DB of about 2800 instances of a class that has two java.lang.String members : toExtension and fromExtension. There are other members in the class, but not relevant to the problem.   A query like this causes the java process

@Indices({ @Index( members ={"oidId", "type"}), @Index( members ={"parentAcl"}) }) public class TestEntity

( members = {"recurrence.recurringEvent"}),     @Index ( members = {"relations.related

Hi There I am using ObjectDB 2.6.3. I get the following Exception when I try to read my entities with a query where I have set to use LAZY initalization. It fails when it tries to set a 1:n member ... hints? The Mapping of class Modell and its member : @Entity class Modell { ... @OneToMany(fetch

be necessary, instead we could use maps for the international members and provide a map entry for each ... -language members where for example the long description would be even stored as a rather long HTML code

A a, B b WHERE a = b.a OR a MEMBER OF b.list ... The query will have to be adjusted to your specific ... : SELECT DISTINCT b FROM B b WHERE :a = b.a OR :a MEMBER OF b.list ...   support Support

There's a static member in line 28, kind of a wrapper class to the database service class that does the queries

Hi Sir,    I have a persisted field of the type:   List groupMembers   How do I check if a particular member exist in one of the group? snoopydoghk Ka Leung Nesting a collection directly in another collection, although supported by ObjectDB, is not valid in JPA. Accordingly

/java/jpa/entity/index For example: @Unique ( members ={"lastName","firstName"}) And for a single

Greetings ObjectDB team, Suppose I pass a List of persistent objects to some query as a parameter, can I navigate to those objects' fields ? E.g.: SELECT x FROM ClassX x WHERE x.a IS MEMBER OF :y.b Thank You ! geekox86 Mohannad AlAwad You cannot navigate from a collection of objects

( { @Index( name = "MyClass_ind_1", members = { "oid" }, unique = "true" ) } ) @Entity public class

index on TestEntity instead: @Entity @Index( members ={"state.entityState"}) public class TestEntity

= -1"), } ) @Indices( { @javax.jdo.annotations.Index( members = {"id","pwd","access"}) } ) public

Dear support members , I am trying to set up a replication url in objectdb.conf and have the the following error in the log files: [ObjectDB 2.3.4] javax.persistence.PersistenceException Failed to connect to server 127.0.0.1:6136 (Connection refused) (error 522) at com.objectdb.jpa.EMF

= CascadeType.REMOVE) private Values valuesRef; }   @Index ( members = {"step.stepNumber"}) @Entity

I'm trying to fetch a list of entities, by their Id. I Use this query: SELECT c FROM User c WHERE c.id IN :ids This querey works as long as I don't set the property "id" as @Id. If i set @Id to any other member , this query works, if I set id as @Id, it stops working and gives zero results

entity object member variables rather than getters and setters. I think if you use the @Warning

I'm trying to switch an application that worked fine in Hibernate to ObjectDB and am having issues with queries that reference enum types. On my entity object is a static enum public static enum Type {     A,B,C } that is stored in an @Enumerated member variable private Type type

and stays like member defined in class id, timestamp, keyDescriptor, dataItems, codedDataBlock, level I

and includes both the entity class field and the embedded class field, e.g.: @Entity @Index( members

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 anyone have an idea on how i could formulate that as Typed or CriteriaBuilder query? Thanks.   @Entity

/objectdb/bin/objectdb.jar I saw the Meta still has two sets of members , see the attachment! TIA gzdillon

- members to a list A whatever of kind (maybe objectDB-intern)     - It then gets

Hello ObjectDB Team I might have read the solution to this issue some times before, but I could not find an answer now. So sorry for bothering you. I want do add an @Index annotation to a member of an existing Entity. This changes affects also existing databases. Is there any best practice

A other; } so entity B is the owner. Now I persisted 2 entities of type A. In the first one, the member

of fields (Content- Members ) is changed alternately (48/49, 51/52), which indicates

WHERE ( artifactActivatedGoals MEMBER OF ?1 OR artifactActivatedAssumptions MEMBER OF ?1 OR artifactActivatedCalibrations MEMBER OF ?1 ) AND artifact MEMBER OF instanceEntryArtifactSet.artifacts  

({         @Index( members = {"children.name"}),         @Index( members = {"children.age"})     })   ... , which is much more efficient for the third query: @Index( members = { "children.name", "children.age" }) (with or

;  @Indices({         @Index( members = {"children.name"}),         @Index( members = {"children.age"})   

.execution.ExecutionConfigImpl as config WHERE execution MEMBER OF ?1 AND execution.verdictID = verdict.uid ... .dmos.execution.ExecutionConfigImpl as config WHERE config.uid = '23A' AND execution MEMBER OF ?1

property method names . Fixed a bug in retrieving pure time values (java.sql.Time). Fixed a bug in MEMBER

I modified the example code to include an index on the Point class like so:     @Index( members ={"x","y"}) Then when I run the following query:     TypedQuery query = em.createQuery("SELECT p FROM Point p where p.x = :y",         Point

I have a method to calculate some values before persisting to the database. So i annotated it with @PrePersist . If i merge an object the annotated method get's called but all members are on their default values. I only tried it with new objects. So merge get's an object with id = null