About @Query

forum_thread

Unexpected COUNT Results

We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB explorer: 1.       Using ObjectDB explorer #1 2015-03-06 14:57 We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have ...

 
forum_thread

Unable to execute update query

Hello! I'm trying to do an update query via the explorer to set a new field value for around 400k objects. UPDATE Position p SET p.originalData = null This exception raises when I try to do it: #1 2016-01-28 14:33 Hello! I'm trying to do an update query via the explorer to set a new field value for around 400k obj ...

 
forum_thread

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java) takes about 10sec. I am using a recent MacBook (SSD blabla - disk I/O speed is about 400MB/sec - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146/400 = 0.35sec.. + some overhead). I was wondering if this kind of speed is "normal", or if this is something I should investigate. Thanks EKK #1 2015-08-29 21:10 Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java) ...

 
forum_thread

Duplicate Entity class names causes Exception in Query

I have two Entities which have the same class name but reside in different packages, only one of them is mentioned in the persistence.xml. I a NamedQuery I use the unqualified class name of one of these entities. If I execute that query I get an exception;   #1 2011-08-25 12:40 I have two Entities which have the same class name but reside in different packages, only one of them is mentione ...

 
release

2.3.3

Release date: 2011-11-10 Download (5.49 MB) Binary:  objectdb-2.3.3.zip You should start by following a  tutorial or reading the manual ...

 
api-jpa

JPA Annotations for JPQL Queries

Reference (JavaDoc) of JPA 2 query annotations, including @NamedQueries, @NamedQuery and @QueryHint. The following annotations are used to define static named JPA queries: javax.persistence.NamedQueries javax.persistence.NamedQuery javax.persistence.QueryHint The JPA Named Queries section of the Objec ...

 
release

2.3.4

Release date: 2011-11-25 Download (5.49 MB) Binary:  objectdb-2.3.4.zip You should start by following a  tutorial or reading the manual ...

 
forum_thread

Help with JPA2 Criteria and conditional operator grouping

Hi,   I'm getting a little trouble performing a query as per the way I had it set up on eclipselink. Essentially, the query I'm trying to generate is: SELECT $1 FROM Company $1 WHERE (($1.companyId=:p1) AND ($1.conditionOne=true)) AND (($1.conditionTwo=false) OR ($1.conditionThree=false))   From the JPA2 criteria: #1 2011-07-13 13:51 Hi,   I'm getting a little trouble performing a query as per the way I had it set up on eclipsel ...

 
forum_thread

Query for objects persisted within the same transaction

I have a question concerning reading uncommited entities with query, within active transaction. For example, I read data from file. Each line contains value of one of entity's attributes but those values are not unique, so it's possible to have a multiple instances of the same entity. To eliminate duplicates, after reading every line I first check using a query, if an entity with that attribute value already exists. If no - I create one and persist it. #1 2011-01-31 13:47 I have a question concerning reading uncommited entities with query, within active transaction. For examp ...

 
forum_thread

Object as parameter results in exception

Hi,    I've got a simple JPA2 Criteria query which fails when doing an object equality. I verified this against EclipseLink and over there, it works. I'll Attach some code snippets to help figure it out:   @Entity() public class Product{ . . . @ManyToOne     private Compamy owningCompany; } @Entity() public class Company{    .    .    .     @Id    private Long id; } and the query: #1 2011-04-27 12:15 Hi,    I've got a simple JPA2 Criteria query which fails when doing an object equality. I v ...