[jboss-user] [EJB 3.0 Users] - Re: NamedQuery problem: TABLE is not mapped

2009-11-25 Thread Wolfgang Knauf
I'm sorry, I was wrong with the casing of the property. You are right, it has to be lower case. Getter/Setter getArtnr/setArtnr indeed form a property artnr. Wolfgang View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4267487#4267487 Reply to the post :

[jboss-user] [EJB 3.0 Users] - Re: NamedQuery problem: TABLE is not mapped

2009-11-25 Thread pi4630
Thank *you* :)! View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4267501#4267501 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4267501 ___ jboss-user mailing list

[jboss-user] [EJB 3.0 Users] - Re: NamedQuery problem: TABLE is not mapped

2009-11-24 Thread Wolfgang Knauf
Hi, in your named query, you have to use the name of the entity bean class, not the table name. So it should be SELECT a FROM Artikel a ORDER BY a.Artnr. If the property has getter/setter getArtnr/setArtnr, it has to be named Artnr in the query. Hope this helps Wolfgang View the original

[jboss-user] [EJB 3.0 Users] - Re: NamedQuery problem: TABLE is not mapped

2009-11-24 Thread pi4630
Wolfgang, thanks for caring, thumbs up! The book I'm studying does not mention case sensitivity, and I thought the statement would be table related, not class related. So thank you very much, because after changing the case, it worked. There's one thing: I have indeed a artnr field and public