Hi,
I wonder, whether it is possible to map (writable and readable) many datasets (lines of a table in database) to one java-Object.

Database table:
Table_name (column_id, column_nr)
Datasets in table: (id_a, 1); (id_a, 2); (id_a, 3); (id_b, 4)

mapping java-Objects:
Object1:
ID: id_a ; setOfNr: {1,2,3}

Object2:
ID: id_b ; setOfNr: {4}

Is there any way for a mapping like this without any additional table in hibernate annotations?
I have a solution with one additional table and embed. This table has to store distinct ids (id_a,id_b).

Best regards
gimlitz

Don't think it is possible to do this without additional tables.. The reason being RDBMS each column can only have one value.

Regards,
Nagendra

Could you possible use an array in you Java code, and map that array to a @Lob in your database? Hibernate could then put in and pull out the array?

Thanks for your answer. I suspect the same also.

Regards Wolfram

One note here is using LOB would make your data non searchable as this is no more treated as text but as binary..

I am sure u must be already aware of this.

Regards,
Nagendra

Thanks for the Idea using LOBs, but this will not be a solution in my case.

Regards Wolfram