Hibernate version:3

Name and version of the database you are using: Postgree

How I do hibernate mapping when one of the fields of the composite-id is a sequence ??? The sequence I can do into "generator", that is into of "id".But in this case, I use <key-property>, and it dont work with "generator".
Can Someone help me? I m brazilian, sorry the bad english..rs

How can you have sequence for composite key? As I know, sequence are objects in Database that retrieve a single value. The id of your class don't represent the PK on your table? I think there's something wrong on your model. Give more details...

My PK has two fields: one is integer....and the other too......
id_hist (integer)
id_subprod (integer)

but id_hist I want as a auto-increment....in Postgree...I have to have a sequence....

please helpe-me

You do have a work around of having your own id generator....

basically this id generator should execute following SQL and should give you id

select sequencename.nextval from dual.

you can refer to documentation from the site or example given in book for working with composite id for the same

sudhir

Where I can insert this code? (select sequencename.nextval from dual)
I think this is exactly I want....

If you have some topic or link about it, tell me please.

thank