15 | 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 |
15 | JPA - ExceptionInInitializerError when creating EntityManager> emailSettings = emTemp.createNamedQuery("EmailSettings.findByName", EmailSettings.class).setMaxResults ... (Name))='SHIFTATTENDAFTERSLOT'") .setMaxResults(1).getSingleResult(); if (minutes != null && minutes |
11 | Selecting random rowsHello 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 |
11 | New to Product & Having An Issue = em.createNamedQuery("Department.findAll", Department.class); q.setMaxResults(1000 |
11 | 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 |
11 | Mapped By Fetch is very Slow.setMaxResults(10000).getResultList(); Long end = new Date().getTime(); Long duration = (end |
11 | slow performance for a complex query set with setFirstResult and setMaxResults. I could do this with subqueries, however as I understand |
11 | Sorting problem() and setMaxResult(); lwalkowski Lukasz Walkowski Your query works well with a small change |
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 |
2 | Threaded Test - Failed to commit transaction: Unexpected internal exception"); Point p = (Point)q.setMaxResults(1).setLockMode( LockModeType.PESSIMISTIC_WRITE |
