ObjectDB ObjectDB

Internal Website Search

11-20 of 28 resultsRefresh

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

Performance problem

);         queryAkt.setFirstResult(i); queryAkt.setMaxResults(20); queryAkt ... AktImpl e", AktImpl.class);         queryAkt.setFirstResult(i); queryAkt.setMaxResults

Selecting random rows

Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM

Sorting problem

() and setMaxResult(); lwalkowski Lukasz Walkowski Your query works well with a small change

Mapped By Fetch is very Slow

.setMaxResults(10000).getResultList();   Long end = new Date().getTime();   Long duration = (end

New to Product & Having An Issue

= em.createNamedQuery("Department.findAll", Department.class); q.setMaxResults(1000

Query perfromance problem

).setMaxResults(count).getResultList();    logger.debug("Query executed");   } catch

100% CPU when using multiple BETWEEN

to the first 50 records with Query.setMaxResults(...). Any suggestions? Thank you Emil prolancer Emil

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

Null pointer exception being thrown from within ObjectDB.

{   *****POINT OF FAILURE***** */       reportDownloadObjects = query.setMaxResults(maxRecords

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