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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
