Hello,

I have a question regarding how to retrieve records from a table that consists with one composite key.
In my hbm.cfg I have specified my composite key with this section:

<composite-id>
<key-property name="year"/>
<key-property name="month"/>
</composite-id>

I have a POJO class with all the "columns" that exists in my table.
How should I write this POJO class regarding to my composite key.

In the same package I hava a DAO class that retreives all records from the database.
How should I write a DAO method that retrieves all records from the table regarding to my composite key.
SQL query: select year,month,sallary from sallary where year>=2002

If I don't specify the composite key in my hbm.cfg hibernate retrieves too many records in my DAO object.
One record will be listed several times in the query result. Don't know why!

I wonder how is it possible to have a UNIQUE identifier that's based on YEAR and MONTH, while you store salaries.

Is this really the Primary Key on that table?

It is an example of my problem. This is not the real program.

Unless you provide the actual problem and a lot of info about what you are trying to do, there is little chance that you'll get the right answer.

Hmm, so is it impossible to describe for me the priniciples on how to retrieve records from a table with a composite key?

Have you checked our User Guide?

Can I use this guide for Hibernate 3.2?

This guide is written for Hibernate 5. We no longer maintain Hibernate 3 or 4. You can check the old documentation, but it's not as neat as the Hibernate 5 one, which was rewritten from scratch.

While I can surely help you if you are using annotations, I haven't used any legacy XML mapping for the past 8 years, so I don't remember the quirks associated with those mappings. Anyway, the legacy HBM mapping is going to be deprecated in a future version of Hibernate, so you are going to find less and less resources for such an old version of Hibernate.