hi,

I have a table IO which contains a Set <String> of labels:


So, you will have a table LABELS like this:

IO_ID LABEL
1 Car
2 Food
3 Car
...

Now, I want it to return a (distinct) list of all LABEL in the table LABELS.
I've tried about anything but I can't get this (you would think so) simple function to work.

Hopefully, someone can tell what stupid mistake(s) I've made?

tx a lot,
Stijn

You have to define label as an entity if you want to do some queries on labels like "from Label".
As label is an element in your case you cannot access it directly in your hql queries

tx,

I've tried that and it works; however, I'm not thrilled by the fact that I have to create a class Label with simply a property Label but I can live with it.

Could you help me out with 2 related questions?

1. return getHibernateTemplate().find("from Label");

Do you also know how I can get a distinct list of labels?

2. Actualy I have a joined-subclass-structure going on:

IO is the super-class of Cost & Incoms, so I also have 3 tables (IO, Cost & Incoms). Labels are kept in IO. How can I fetch a list of labels only containing the labels referenced by Cost?

I've tried:

"from Label where l.IO_ID in (select IO_ID from Cost)"

"from Label l join Cost c "

"from Label l join Cost c where l.IO_ID = c.IO_ID"

All of these give exceptions.

tx!
[/img]

never mind, I think I found the solution(s):

"select distinct l.label from Cost c join c.labels l"