There´s any way to do a composite id, where one of the colums is an oracle sequence and the other is a foreign key to other table?

Hibernate version: Hibernate2

Mapping documents:
.
.
.

<composite-id class="MENUSPK" name="Id">
<key-property
column="ID_MENU"
name="IdMenu"
type="integer"
/>
<key-many-to-one
class="Roles"
column="COD_ROL"
name="CodRol"
/>
.
.
.

Name and version of the database you are using:ORACLE 9i

hum hum

just one question: do you think the sequence property isn't enough to manage your model unicity?
;)

not so hard

Yeah, the sequence is enough, but maybe I didn´t made the correct question, I wanted to know if there was a way to tell hibernate to increment sequences using a generator flavor like sequence in it´s tag, but I used a prepared statement to do that, and I got the connection from hibernate of course... :-) and used assigned in the tag. Thaks.

why don't you map the sequence generated column as id

and the many-to-one as a simple many-to-one with not-null = true?