Efficient way to get SingleResultObject in java

Asked May 28 '13 at 02:33

Active Dec 25 '15 at 00:43

Viewed 59 times

I have a query to get the maximum id of a table Eg:Country. Is there any efficient way to get a singleResultObject? There is the possibility to get an Exception while getting a singleResultObject.

Query q = em.createQuery("SELECT MAX(c.countryId) FROM Country c ");

try   
{
   Integer countryId = (Integer) q.getSingleResult();    
}   
catch (Exception e)   
{
   logger.error("Exception " + e);       
}

edited Dec 25 '15 at 00:43

BDL

21,052
22
49
55

asked May 28 '13 at 02:33

muthukumar

2,233
3
23
30

Are you trying to make the query more efficient? or the code smaller? – greedybuddha May 28 '13 at 02:39
1

[this](http://stackoverflow.com/questions/2002993/jpa-getsingleresult-or-null) might help. – neo108 May 28 '13 at 02:40
Make code efficient and run without exception – muthukumar May 28 '13 at 02:55

Efficient way to get SingleResultObject in java

0 Answers0