ObjectDB ObjectDB

Internal Website Search

11-20 of 20 resultsRefresh
17

Caching/Paging Questions...

via setFirstResult and setMaxResult speed up the query execution since there are fewer result objects to bring into ... . Using setFirstResult and setMaxResults could improve performance, but the effect is highly dependent on the specific query. support Support
12

Selecting random rows

Arkadiusz Szymański You may use setFirstResult with a random number. support Support
12

About LIMIT and OFFSET as query tokens

Thanks you in advance mgarciat Miguel In JPA you specify a result range using setFirstResult and setMaxResults. support Support Thanks you!!! mgarciat Miguel
12

slow performance for a complex query

set with setFirstResult and setMaxResults. I could do this with subqueries, however as I understand
12

Sorting problem

: 108 Branch: 109 Branch: 110 Branch: 111 Branch: 112 Branch: 113 The same if I use setFirstResult
12

Iterating over large result set

");     for (Tuple t : q.setFirstResult(page).setMaxResults(pageSize).getResultList()) {         // work
12

Query perfromance problem

.class);   }   try {    logger.debug("Executing query");    prodList = icQuery.setFirstResult(start
12

LIMIT or TOP functions

Is there LIMIT or TOP functions in object db? If so can you provide some examples? vinodh vinodhkumar You can set query result range by using the setFirstResult and setMaxResults methods. You can find more details and an example in the manual. support Support Thanks. This solved my purpose. vinodh vinodhkumar
2

[ObjectDB 2.2.5_02] Unexpected exception (Error 990) com.objectdb.o.InternalException: java.lang.NullPointerException: null

(maxResults); q.setFirstResult(firstResult); } return q
2

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

EventLogPersistEntry p ORDER BY p.id DESC", EventLogPersistEntry.class); query.setFirstResult

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