Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Did that, and did not find anything

One of the project I am working on has following requirements,
Need to store technology names and their versions to a database and also any sub technology it might use. Sub technology is again another technology itself.
A technology may or may not have sub technologies
A technology may have more than one sub technology under it
A technology can be a sub technology for more than one parent technology.
I think this is a case of many to many self reference.

So I have two tables

Technology (TechID, Name, Version) --- The main table
TechSubTech(ParentTechID, ChildTechID) --- The link table

But how do I map this to hiberate mapping files and POJO's??

Can some one please help or tell me if it is possible to do so with hibernate or not?

[b]Hibernate version:[/b]
Hibernate 3.1

You can always break a many to many reference into two one to many references, I guess this would be good approach for you're requirement.

you can try something like this

<class name="Technology">
<set name="subtechnologies" table="TechSubTech">
<key column="ParentTechID"/>
<many-to-many column="ChildTechID"
class="Technology"/>
</set>
<join table="TechSubTech"
>
<key column="ParentTechID" unique="true"/>
<many-to-one name="Technology"
column="ChildTechID"
not-null="true"/>
</join>

</class>

If you are using Oracle, take a look on this one. It will work in your case perfectly.

This in not the right way to promote your stuff man. Not cool.

Why not if there are tools out there where simple things are really simple and not even questionable? Just so people aware of them. They are not obliged to switch are they?

This should do what you want:


Your POJOs should be as you expect: