About @Query

forum_thread

How to query for list of lists ?

Hi, I have a problem with constructing query, that gets only embedded list of integers from Entity. Here's the example : Query query = em.createQuery("SELECT i.filterDescription FROM Inspiration i"); List<List<Integer>> result = query.getResultList(); where Inspiration is like this : #1 2011-11-18 11:05 Hi, I have a problem with constructing query, that gets only embedded list of integers from Entity. Here& ...

 
api-jpa

createQuery(qlString)

Create an instance of Query for executing a Java Persistence query language statement.(Method of javax.persistence.EntityManager)

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System #1 2013-08-05 05:44 Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. ...

 
forum_thread

Query by array element

Hello, I have a class as follows: @Entity public class MyEntity {     boolean properties[]= new boolean[1024]; } I would like to query objects with feature '42': select me from MyEntity me where me.properties[42]=true Is it possible? Thank you! #1 2015-05-05 11:04 Hello, I have a class as follows: @ Entity public class MyEntity { ...

 
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 ...

 
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) ...

 
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

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 ...