Select query not working properly

[Abhinav Sahai]

Hi,

I am doing simple select query on a table, which has three separate records in database.
In the output, I see only one record, 3 times. It seems the rest of the objects are getting overwritten by the first object.

Code:

String qry = "from ImageFileName ifn where ifn.imageID = :ImageID";
List<ImageFileName> ifnList = liveSession.createQuery(qry).setInteger("ImageID", 12051).list();
for (ImageFileName imageFileName : ifnList) {
System.out.println(imageFileName.getImageFilenameID());
}

HBM file:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="livedms.businessobject.ImageFileName" table="image_filename">
<id name="imageID" column="image_id" type="java.lang.Integer">
<generator class="assigned" />
</id>
<property name="imageFilenameID" column="image_filename_id" type="java.lang.Integer"/>
<property name="xwdFilename" column="xwd_filename" type="string"/>
<property name="modelDescription" column="model_description" type="java.sql.Blob"/>
</class>
</hibernate-mapping>

Please help!

[ August 11, 2008: Message edited by: Abhinav Sahai ]

[ August 11, 2008: Message edited by: Abhinav Sahai ]
[ August 11, 2008: Message edited by: Paul Sturrock ]

[Paul Sturrock]

So, you are querying for objects by primary key and expect three results? This sounds like imageID is not actually a primary key. Hibernate identifies object based on primary key (since that is the same logic the database uses). So if it finds one object with a specific id it assumes that is the only object of that type with that id.

[Kuladip Yadav]

Your HBM file says that imageID is primary key.

So resultant ifnList doesn't contains more than one record.

In the output, I see only one record, 3 times.

Then how do you see one record 3 times ?
May be you want to achieve some thing else.

[Abhinav Sahai]

Thanks a lot Paul and Kuldeep.
It was spot on.

ImageID was not the primary key, instead it was image_file_id

Thanks a lot again.