Hello,

I have a pojo with a Collection<Integer> attribute. This attribute must be persisted in the same TABLE than the pojo ((de)normalization): one extra column (COL1-COL2- etc) per element in the Collection. The size of the Collection varies for each instance of the pojo (which means it should be possible to add a column dynamically into the TABLE).

Which Hibernate annotation should I use?

I am lost in the documentation and I don't know in which direction to go. Any help or guidance welcome.

Thank you,

Yves.

---
Extra info (where do I need this):

I need to persist/update a tree (pojo with parent/children attributes).
Every node is a row in a table, and contains the path to the root:
TABLE:
Name - Parent - Parent1 - Parent2 - etc
n1 - 0 - 0 - 0
n2 - n1 - 0 - 0
n3 - n2 - n1 - 0 - 0
etc.
---

Wouldn't it be better to normalise your tables? lol...

As you should have guessed, it is a legacy database used by a working legacy open-source application.

I just need an administrative tool to populate this database from our own databases and my technology of choice is, among others, Hibernate with annotations.

Any suggestion welcome,

Yves