hibernate - mapping PK to 2 colums

i search the web for answer, but all the answers refer to composite id PK. i want two map two columns of type long to PK. one should be regular generated id, and the other should be regular long field.

i have the following mapping:

  <class name="com.company.MyTable" table="My_Table">
        <id name="id" column="id">            
            <generator class="assigned"/>
        </id>
        <property name="jobId" column="job_id" type="long" index="oes_job_id_idx" />
        <property name="serverId" column=开发者_运维百科"server_id" type="long"/>
     </class>

i want to add to the PK the job_id column. how do i do that?

---

Primary keys, by definition should be the unique key with the fewest columns possible:

• your can't have multiple primary keys
• you shouldn't use an additional column for the primary key, if the first column is already unique

It doesn't really give you a benefit to create a separate index either - so stick to the generated field as primary key. So, hibernate doesn't support that because it is a wrong thing to do.

---

Please look at this questions there is a full solution for composite Primary keys:

Mapping same class relation

And then

Mapping same class relation - continuation

Hope it helps.