Select top 1 result using JPA

Question

I need to bring from DB only one single result. How can I do that with JPA?

Select top 1 * from table 

I tried

"select t from table t"

query.setMaxResults(1);  query.getSingleResult(); 

but didn't work. Any other ideas?

Answer 1

Try like this

String sql = "SELECT t FROM table t"; Query query = em.createQuery(sql); query.setFirstResult(firstPosition); query.setMaxResults(numberOfRecords); List result = query.getResultList(); 

It should work

UPDATE*

You can also try like this

query.setMaxResults(1).getResultList(); 

Answer 2

To use getSingleResult on a TypedQuery you can use

query.setFirstResult(0); query.setMaxResults(1); result = query.getSingleResult();