List results = getHibernateTemplate().find("from Support obj where obj.attributeName = 'B PROT CLASS'");

using spring SupportDAO extending HibernateDaoSupport with Hibernate3
Problem: If I should get 10 Support object, they all are same objects. i.e. 10 copies of the first result. What am I doing wrong?

using eclipse for dev and postgres for database...

thank you,

Indu

---------------------------------------------------------------------------------
Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Try following,

String attribName = "B PROT CLASS";
List results = getHibernateTemplate().find("from Support obj where obj.attributeName = ?",attribName);

And please rate it if you find the answer useful.

thank you Beejal for your reply...

still I get copies of the first result row. Just copies???!!!

But

select obj.attributeValueDescription from Support obj where obj.attributeName = 'B PROT CLASS'"

returns right results but an object with one column. I wish I don't have to type in 120 or so columns to get the whole row of data??!!

Does the Support class have descendants? In other words, is it a superclass for some classes like SupportMail, SupportCall etc?

I ask because it looks like you have a problem with inheritance mapping?

How are you accessing the results? Due to lazy evaluation, result isn't a real "List"... maybe turn off lazy evaluation & see if that helps.
______
Dwight
pls rate

this is the set up in the respective hbm mapping file

<class
name="com.domain.objectModel.Support"
table="asarrep"
lazy="false"
>

I hope that sets the lazy evaluation to false I guess. Still the same problem.

to Stijn: No, this class doesn't have a superclass or a subclass, I mean no parent class, no child class.

-Indu