• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting component-based side

 
Hussein Baghdadi
clojure forum advocate
Bartender
Posts: 3479
Clojure Mac Objective C
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey,
User entity has one to many relationship to a component collection.

I want to get the non-expired packages:
select pkgs from Users usr join usr.packages pkgs where pkgs.expiryDate > current_date() and usr.id = :id
The generated SQL is:

But I got the following exception:
Mar 26, 2009 6:12:59 PM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Unknown column 'packages1_.id' in 'field list'
Any ideas?
Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic