Is there anyway in hibernate to process a column of comma delimited FKs in the same manner as if there were a many-to-many linkage table? That is, ideally I could reuse some old table structures that heavily use comma delimited lists instead of creating new join tables everywhere.
Oversimplified Example:
Code:
Table: STUDENTS
id int(4) PK
name varchar(50)
professors text
Table: PROFESSORS
id int(4)
name varchar(50)
Sample data:
Code:
STUDENTS:
ID NAME PROFESSORS
--- ------- -------------
1 Charles 101,102
PROFESSORS:
ID NAME
--- ------
101 Dr. John
102 Dr. Bob
Thanks,
Thad