is there a specific way to write sql queries in entity beans in ejb spec 3 
rather than normal sql query?

i have defined namedquery as follow.
@NamedQueries( [EMAIL PROTECTED](name = "Language.findByAgentCode",
                        query = "SELECT l FROM Language l WHERE l.AgentCode = 
:agentcode")})

but when deploying following exception is thrown

2007-11-28 10:03:31,237 WARN  [org.jboss.system.ServiceController] Problem 
starting service persistence.units:ear=sdb.ear,jar=sdb3.jar,unitName=Language
javax.persistence.PersistenceException: org.hibernate.HibernateException: 
Errors in named queries: Language.findByAgentCode
        at 
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720)
        at 
org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:127)
        at 
org.jboss.ejb3.entity.PersistenceUnitDeployment.start(PersistenceUnitDeployment.java:246)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

pls help me to solve this problem

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4108294#4108294

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4108294
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to