composite id

gabrielmarincola · **Joined:** Mon Mar 21, 2005 3:45 pm **Posts:** 2

Hibernate version: 2.1.6
Name and version of the database you are using:mysql 4.0.16

Hi! I'm in truoble and I couldn't find the solution yet.
I've searched the web once and again and nothing.

My problem is that I have a table with composed id and one of the key fields is of the type "autoincrement". I need to know which number was assigned to this field, but the object returned by the save message of Session class has null as value of the variable corresponding to this field.

Any ideas? Thanx in advance.

Gabriel

anthony · **Posted:** Mon Mar 21, 2005 4:10 pm

Quote:

My problem is that I have a table with composed id and one of the key fields is of the type "autoincrement".

this is not a problem, this is a solution :)
this field is enough to manage your object id, forget composite-d just map this column as the <id/> and the other as a not-null property

max · **Posted:** Mon Mar 21, 2005 5:39 pm

well he will probably run into trouble if he has foreign keys that points to these two at the same time. but then again he should be able to just map the unqiue part and then just maintain the other property in code.

gabrielmarincola · **Joined:** Mon Mar 21, 2005 3:45 pm **Posts:** 2

All right. It worked, but... I must remember to do this everytime I modify the database structure. This is because I'm using middlegen. So then I must touch the generated code manually.

I consider this is a bug... can it be reported as it? would it be propper?

Thanx in advance,

Gabriel

max · **Posted:** Wed Mar 23, 2005 11:54 am

well its a broken model so no I would not consider it a bug.

You could also try and use the SelectGenerator which allows you to go fetch stuff via an select. but i don't know if that will help you.