HI,
i added this catch, "ex.printStackTrace"
and this is what i got;
Exception Description: Error compiling the query [select sum(o.montant) from
Operation o,Transaction t,Caisse c where
(o.cod_transac=t.code)and(t.sens='C')and (o.cod_caisse=c.code_caisse)], line
1, column 72: unknown state or association field [cod_transac] of class
[newpackage.Operation].
at
oracle.toplink.essentials.exceptions.EJBQLException.unknownAttribute(EJBQLException.java:474)
at
oracle.toplink.essentials.internal.parsing.DotNode.validate(DotNode.java:101)
at
oracle.toplink.essentials.internal.parsing.Node.validate(Node.java:115)
at
oracle.toplink.essentials.internal.parsing.BinaryOperatorNode.validate(BinaryOperatorNode.java:58)
at
oracle.toplink.essentials.internal.parsing.EqualsNode.validate(EqualsNode.java:65)
at
oracle.toplink.essentials.internal.parsing.Node.validate(Node.java:115)
at
oracle.toplink.essentials.internal.parsing.LogicalOperatorNode.validate(LogicalOperatorNode.java:63)
at
oracle.toplink.essentials.internal.parsing.Node.validate(Node.java:115)
at
oracle.toplink.essentials.internal.parsing.LogicalOperatorNode.validate(LogicalOperatorNode.java:63)
at
oracle.toplink.essentials.internal.parsing.WhereNode.validate(WhereNode.java:58)
at
oracle.toplink.essentials.internal.parsing.ParseTree.validate(ParseTree.java:235)
at
oracle.toplink.essentials.internal.parsing.ParseTree.validate(ParseTree.java:211)
at
oracle.toplink.essentials.internal.parsing.ParseTree.validate(ParseTree.java:201)
at
oracle.toplink.essentials.internal.parsing.EJBQLParseTree.populateReadQueryInternal(EJBQLParseTree.java:134)
at
oracle.toplink.essentials.internal.parsing.EJBQLParseTree.populateQuery(EJBQLParseTree.java:108)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:219)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:189)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery(EJBQueryImpl.java:153)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:114)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>(EJBQueryImpl.java:99)
at
oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>(EJBQueryImpl.java:86)
at
oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:204)
... 48 more
- i'd like to add an information is that i created a simple
query,(selection from one table) and it works correctly,
--
View this message in context: http://www.nabble.com/exception-occurred-while-creating-a-query-in-entitymanager-tp18801763p18806535.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.