Criteria is returning duplicate rows. When I execute the hibernate generated query in DB then it returns different rows. Here are the details :

Mapping xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- Generated Feb 16, 2012 11:42:13 AM by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.xxxx.xxx.xxx.xxx.xx.xxxx.dataobjects.ETLTableKeysDO" table="ETL_TABLE_KEYS">
<id name="dbName" type="java.lang.String" access="field">
<column name="DB_NAME" />
<generator class="assigned" />
</id>
<property name="tableName" type="java.lang.String" access="field">
<column name="TABLE_NAME" />
</property>
<property name="busObjKeyColumnName" type="java.lang.String" access="field">
<column name="BUS_OBJ_KEY_COLUMN_NAME" />
</property>
<property name="srcKeyColumnName" type="java.lang.String" access="field">
<column name="SRC_KEY_COLUMN_NAME" />
</property>
<property name="busObjSrcKeyColumnName" type="java.lang.String" access="field">
<column name="BUS_OBJ_SRC_KEY_COLUMN_NAME" />
</property>
<property name="srcColumnDataTypeChange" type="java.lang.String" access="field">
<column name="SRC_COLUMN_DATA_TYPE_CHANGE" />
</property>
<property name="processSK" type="long" access="field">
<column name="PROCESS_SK" />
</property>
<property name="keyColumnName" type="java.lang.String" access="field">
<column name="KEY_COLUMN_NAME" />
</property>
</class>
</hibernate-mapping>



GET Method :

public List getETLTableKeysDOList(String dbName,String tableName)
{
Session metadataSession = HibernateUtil.getMetadataSessionFactory().openSession();
//Create criteria for the required class
Criteria criteria = metadataSession.createCriteria(ETLTableKeysDO.class);
Transaction transaction = null;
List resultList = null;
try {
//Add the required search property to criteria
criteria.add(Restrictions.eq("dbName", dbName).ignoreCase());
criteria.add(Restrictions.eq("tableName", tableName).ignoreCase());

transaction = metadataSession.beginTransaction();
resultList = criteria.list();
transaction.commit();
}
catch (HibernateException e ) {
EDWLogger.error(e.getMessage(),e,null);
transaction.rollback();
}
finally {

metadataSession.close();
}

return resultList;

}

How to fix this issue ?

Can you please report here the hibernate generated query?
Which version of Hiberante are you using?