From: chflb <labidi.chifa_at_gmail.com>
Date: Sun, 3 Aug 2008 12:37:01 -0700 (PDT)

hello all,
please do you know what is wrong in my query,in fact i have executed it in
oracle and it works,
but while running my project this message appeared" exception occurred while
creating a query in entitymanager".
this is the procedure;

public void Opinfo() {
        EntityManager em = getEntityManager();
        try {
            Query q = em.createQuery("select sum(o.montant) from Operation
o,Transaction t,Caisse c where
(o.cod_caisse=c.code_caisse)and(t.sens='C')and(o.cod_transac=t.code)");
            infoArrete.setTotD((BigInteger) q.getSingleResult()) ;
        } finally {
         em.close();
        }
    }

thanks,
   

-- 
View this message in context: http://www.nabble.com/exception-occurred-while-creating-a-query-in-entitymanager-tp18801763p18801763.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.