51 | 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 |
50 | query on calendar classHello! I'm looking for help to build query on calendar class. I need to get objects where Calendar ... 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(1 |
50 | slow performance for a complex queryHi, 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 |
50 | Error using query with MAX() functionI have a class that is persisting a Entity that holds remarks and a time. Then when I query ... an ObjectDB bug in processing large objects in queries. Please try build 2.2.2_02 that should fix this issue ... set to debug. [2011-05-02 21:10:36 #150 query.manager] <queryRequest query="SELECT MAX($1.addDate |
50 | how to query by properties of onetomany relations? (Error 990) future versions. However, this query is invalid. You cannot navigate through collections in JPQL directly ... . This specific query should be rewritten as follows: select f from Foo f join f.bars b where b.name = ?1 ... and such a query was possible for embedded objects. i adapted my query and it works like expected. thanks |
49 | 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 ... is a single new object and is wrapped in a transaction. 2. The 2nd EntityManager runs the queries |
49 | Help with 'not like/lower' queryHi 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 |
49 | possible index required for improving query performance; } With the following query: TypedQuery<BaseObject> 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 |
49 | JPA query of a Set of termsHi, Is it possible to write a JPA query to select objects that contain a collection of elements ... WHERE si.term ????",Page.class); I want the query to give me all Pages that match all of the search terms ... that are already persisted. TypedQuery<Page> query = em.createQuery( "SELECT DISTINCT si.page |
9 | InternalException when using MEMBER OF on a large list in a queryHello, 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 |
