Hi

I have a table with many columnts having same id as the foreign key
For example the table looks like

id status description
--------------------------
1 status1 description1
1 status2 description2

I have written a query like
Query query = session.createQuery("from dbname as db where db.id='1' and db.status='status1'");
for (Iterator iterate = query.iterate(); iterate.hasNext();)
{
dbname db=(dbname)iterate.next();
System.out.println(db.getDescription());
}

The error is "More than one row with the given identifier was found"


Can anyone help me out in this regard