Home » Search

About setMaxResults

21-28 of 28Refresh
Forum
2

New to Product & Having An Issue

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

Query perfromance problem

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

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

slow performance for a complex query

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

Sorting problem

() and setMaxResult();     Your query works well with a small change: String q = "select br from
Issue
2

Threaded Test - Failed to commit transaction: Unexpected internal exception

("SELECT p FROM Point p");                 Point p = (Point)q.setMaxResults(1).setLockMode
Issue
2

Null pointer exception being thrown from within ObjectDB.

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

Retrieve latest entry in a time-series

em.createQuery("...").setMaxResults(1).getSingleResult(); jshaffstall