ObjectDB ObjectDB

Internal Website Search

161-170 of 200 resultsRefresh

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

query on calendar class

Hello! 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

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

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

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

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

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

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

JPA query of a Set of terms

Hi, 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

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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support