I inherited a legacy DB that has a comma-delimited FK column. I am wondering if there is a way I can map this in the mapping file to delimit the commas and return a Set of the entity objects? Or will I need a custom type?

TIA,
Lou

Hibernate version:
3.1.1

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

I think that UserType is your only solution, that I know of.
And that is what it is intended for...
see page 71:
http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf