Hibernate version:
3.2

Mapping
Works fine. The main class involved is the following
class Playlist{
List<String> _files;
//and appropriate get/set methods

}
Where the collection is mapped using an indexed join table.

Question
I'm trying to come up with a HQL query that will find if there exists any playlists with filenames equal to something OR something OR something

The current (working) HQL I have atm is:

select count(play) from Playlist as play

What I think I want is something of the form:

select count(play) from Playlist as play where play.files.element in ('something', 'somethingelse')

But the latter doesn't work. Anyone has a clue on what syntax I should use for this case?

The exception i'm getting:

org.hibernate.QueryException: cannot dereference scalar collection element: element [select count(play) from com.abc.def.ghi.Playlist as play where play.files.element in ('bg800x600.jpg')]

I believe this could work:

select count(play)
from Playlist play
join play.files file
where file in ('something', 'somethingelse')

Now I just wish it was possible to pass in an array or List of strings instead of 'something','somethingelse', but that's another story... :)

Hmm, very interesting. I'd gotten something working, but I wasn't entirely satisfied with it:

select count(play) from Playlist as play where 'something' in elements(play.files) or 'somethingelse' in elements(play.files)

Yours is much more elegant. Works fine too. Many thanks.

You're welcome, please rate! :)