10 | slow performance for a complex query set with setFirstResult and setMaxResults. I could do this with subqueries, however as I understand |
10 | Retrieve latest entry in a time-series result only: return em.createQuery("...").setMaxResults(1).getSingleResult(); support Support |
10 | Left join fetch behaviour doesn't retrieve children? = query.setMaxResults(10000).getResultList(); Long end = new Date().getTime(); Long |
10 | LIMIT or TOP functionsIs 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 |
10 | Iterating over large result set"); for (Tuple t : q.setFirstResult(page).setMaxResults(pageSize).getResultList()) { // work |
2 | Issue with cascade delete & add/remove(); contact = (Contact) em.createQuery("SELECT FROM Contact") .setMaxResults(1 |
2 | Threaded Test - Failed to commit transaction: Unexpected internal exception"); Point p = (Point)q.setMaxResults(1).setLockMode( LockModeType.PESSIMISTIC_WRITE |
2 | [ObjectDB 2.2.5_02] Unexpected exception (Error 990) com.objectdb.o.InternalException: java.lang.NullPointerException: null)); Query q = em.createQuery(cq); if (!all) { q.setMaxResults |
