About query

151-160 of 200Refresh
Forum
21

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the loaded list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed, and, when I querying for primitive ... side does not any diference. The problem is only solved when changing the query mode, from
Forum
21

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in ... , approvePhoneNumber, .... because the parameters equivalent. I want to sort them in the query by their sum ... them. You can calculate it in a JPA lifecycle event. Currently you cannot convert boolean to int in queries
Forum
21

Queries are slow on a large database

and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query ... use such query: Query query = pm.newQuery(MessageImpl.class,     "this.logTestRunId
Forum
21

query on calendar class

Hello!   I'm looking for help to build query on calendar class. I need to get objects ... ;     private String A;     @Temporal(TemporalType.TIMESTAMP) private Calendar start; I tested: Query query=em.createQuery("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query.setParameter
Forum
21

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 ... ')))) I've also tried running the CDI query first and passing the results into the organisation query as ... uploaded for issue http://www.objectdb.com/database/forum/350 This query in both variations takes over 3
Forum
21

Error using query with MAX() function

I have a class that is persisting a Entity that holds remarks and a time. Then when I query ... processing large objects in queries. Please try build 2.2.2_02 that should fix this issue. Thank ... to debug. [2011-05-02 21:10:36 #150 query.manager] query="SELECT MAX($1.addDate) FROM
Forum
21

how to query by properties of onetomany relations? (Error 990)

. However, this query is invalid. You cannot navigate through collections in JPQL directly. You have to use JOIN to define a variable that will iterate over the collection elements. This specific query ... sql joins :) in my last projects i have been using mongodb and such a query was possible for embedded
Forum
21

First query takes 4+ minutes to complete

query that we run on the DB which contains about 320,000 records of a single type of object. SQLite ... to the query that we run). @Entity(name="RecordingMetaData") @SequenceGenerator( name ... the queries (JPQL SELECT statements) shown next.  Query We test with the following query: SELECT r from
Issue
21

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 InternalException ... ) (... more see attached Image) Our query looks like this: String recordClassName = CoverageRecordImpl.class.getName(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid
Manual
21

Index Definition

Querying without indexes requires iteration over entity objects in the database one by ... the iteration can be avoided and complex queries over millions of objects can be executed quickly ... ; : } Indexes in Queries ObjectDB manages a BTree for every index. A BTree is an ordered map data structure