Java EE (Java Enterprise Edition) General Discussion

Hi,

I have a problem with getSingleResult(). It seems very slow , around *400 milliseconds.*
I'm using Oracle Toplink essentials JPA implementation.

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