Home » Search

About query

161-170 of 200Refresh
Forum
11

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
11

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
11

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
11

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
11

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
11

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
11

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
11

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
Forum
10

Help with 'not like/lower' query

Hi all,   Honestly, I'm fairly new with JPA2 Criteria queries - but as far as code effort goes, it has saved me a bit of pain. I'm writing a dynamic query builder (only 1 level deep for basic entities) - but  even though I get most queries to work, I am getting the following error. This is using
Forum
10

possible index required for improving query performance

; } With the following query: TypedQuery query = em().createQuery( "SELECT r.party FROM Relationship r ... =RelationshipType."+type.toString(), BaseObject.class); query.setParameter("otherParty_id", otherParty); query.setParameter("pclass", partyClass); We have noticed that this query slows down in