Hi,
I have a problem with getSingleResult(). It seems very slow , around 400
milliseconds.
This is a piece of my code: (Do you see anything wrong in it?):
public <T> T findUniqueByX(Class<T> source_class, String field, Object
value)
{
Object o = null;
T ot = null;
StringBuffer sbQuery = new StringBuffer();
sbQuery.append("SELECT x FROM ");
sbQuery.append(source_class.getSimpleName());
sbQuery.append(" x WHERE ");
sbQuery.append("x.");
sbQuery.append(field);
sbQuery.append("=?1");
Query q = em.createQuery(sbQuery.toString());
q.setParameter(1, value);
try
{
o = q.getSingleResult();
ot = source_class.cast(o);
}
catch (javax.persistence.NoResultException e)
{
ot = null;
}
return ot;
}
Thanks in advance
--
View this message in context: http://www.nabble.com/getSingleResult%28%29-.-It%27s-very-slow...-tp16618446p16618446.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.