[jboss-user] [EJB 3.0] - Problem with named query...
EricChile
do-not-reply at jboss.com
Mon Dec 4 13:14:58 EST 2006
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
More information about the jboss-user
mailing list