Hibernate Community • View topic - session.list() outputs Entity list with same values

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

session.list() outputs Entity list with same values

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

RShelley

Post subject: session.list() outputs Entity list with same values

Posted: Wed Dec 23, 2009 9:33 pm

Newbie

Joined: Wed Aug 06, 2008 2:18 pm
Posts: 5

I'm attempting to get a list of entities, but the returned collection contains multiple objects with all the same values.

When I get the same list of just object arrays (without the "addEntity" call), the collection correctly contains all different values.

When I execute the query against the database directly, I correctly get a recordset with all different values.

Is there a reason why the following code would return multiple objects with all the same values (the values of the first row in the resultset) when the resultset that's returned has rows with all different values?:

session.createSQLQuery(select * from testTable).addEntity(TestModel.class).list();

Thanks!

Top

RShelley

Post subject: Re: session.list() outputs Entity list with same values

Posted: Wed Dec 23, 2009 11:59 pm

Newbie

Joined: Wed Aug 06, 2008 2:18 pm
Posts: 5

I've tried three different queries and the list of entities always comes back with duplicate values where the object array is correct:

Code:

Query query1 = session.createQuery(" from testTable WHERE userId=:userID");
query1.setParameter("userID", userId);
List hqlList = query1.list();
                  
SQLQuery query2 = session.createSQLQuery("select * from testTable where userId=:userID").addEntity(TestTable.class);
query2.setParameter("userID", userId);
List sqlList = query2.list();

SQLQuery query3 = session.createSQLQuery("select * from testTable where userId=:userID");
query3.setParameter("userID", userId);
List objArray = query3.list();

Only query3 (the object array) returns correct with different records, the contain duplicate objects of the first record.

Top

RShelley

Post subject: Re: session.list() outputs Entity list with same values

Posted: Thu Dec 24, 2009 12:12 am

Newbie

Joined: Wed Aug 06, 2008 2:18 pm
Posts: 5

I have also tried the following with the same result:

Code:

Criteria criteria = session.createCriteria(TestModel.class);
criteria.add(Expression.eq("userId", userId));
criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
List critList = criteria.list();

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum