I need to bring from DB only one single result. How can I do that with JPA? I tried "select t from table t" but didn't work. Any other ideas? Answer Try like this It should work UPDATE* You can also try like this

Select top 1 result using JPA

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

Select top 1 * from table

JavaScript
​x
 
Select top 1 * from table​

I tried

“select t from table t”

query.setMaxResults(1);

query.getSingleResult();

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

but didn’t work. Any other ideas?

Answer

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();

JavaScript
 
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();

JavaScript
 
query.setMaxResults(1).getResultList();​

Advertisement

Answer