[jboss-user] [EJB 3.0] - Problem with named query...

[EricChile]

I am getting the following error when deploying because of a named query. It seems that hibernate is not following the mapping correctly?

org.hibernate.QueryException: could not resolve property: serviceCode of: org.usiis.model.ProviderUsers [select o from org.usiis.model.Users o Where o.providerUsersList.providerId = :providerId AND o.providerUsersList.providerUserServicesList.serviceCode = :serviceCode AND (o.providerUsersList.providerUserServicesList.
  | dateEnd <= :endDate OR o.providerUsersList.providerUserServicesList.dateStarted is null)order by o.username ]
  | 

BEANs

Users

  | 
  | @Entity
  | @NamedQueries({
  |   
  |     
  | @NamedQuery(name = "Users.findAllInactiveByProviderIdServiceCodeDate", 
  |     query = "select o from Users o Where o.providerUsersList.providerId = :providerId " +
  |     "AND o.providerUsersList.providerUserServicesList.serviceCode = :serviceCode " +
  |     "AND (o.providerUsersList.providerUserServicesList.dateEnd <= :endDate " +
  |     "OR o.providerUsersList.providerUserServicesList.dateStarted is null)" +
  |     "order by o.username ")   
  | 
  | 
  |     @Id
  |     @Column(name="USER_ID", nullable = false)
  |     private Long userId;
  |     @OneToMany(mappedBy = "users")
  |     private List<ProviderUsers> providerUsersList;
  | 
  |     
  | 


ProviderUsers


  |     @Id
  |     @Column(name="PROVIDER_USER_ID", nullable = false)
  |     private Long providerUserId;
  |     @Column(name="PROVIDER_ID")
  |     private String providerId;
  |     @OneToMany(mappedBy = "providerUsers")
  |     private List<ProviderUserServices> providerUserServicesList;
  | 
  | 

ProviderUserServices


  |     @Column(name="DATE_END")
  |     private Timestamp dateEnd;
  |     @Column(name="DATE_REQUESTED", nullable = false)
  |     private Timestamp dateRequested;
  |     @Column(name="DATE_STARTED")
  |     private Timestamp dateStarted;
  |     @Column(name="SERVICE_CODE", nullable = false)
  |     private Long serviceCode;
  |     @Id
  |     @Column(name="USER_SERVICES_ID", nullable = false)
  |     private Long userServicesId;
  | 


Why does hibernate want to associate  serviceCode with ProviderUsers when it is in ProviderUserServices in the query? Is this a bug with hibernate?

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

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3991065