Hibernate Result Set Different then SQL Result Set

[Ankit V Agrawal]

Hi,

I'm running a query to fetch some 100 records from the database. The Database is SQL Server 2008.
When I'm running the query from the MS SQL Management Studio it is returning the correct result set.
But when I'm running it thru hibernate the result set is different.

I have tried to print the query and the query is being printed exactly as what I want it to be. Still the result set is different when I iterate thru the list and print it.

Also I have checked that the my code is connecting to the correct data base.

Any idea if hibernate does some kind of caching issues ? Has anybody faced this kind of problem before ?
Any help would be appreciated.

Regards,
Ank

[Ankit V Agrawal]

I tried to test the query thru JDBC and that is also returning the right result. So it has got to do something with hibernate.

2 Records fetched
Transaction ID From Hibernate :: 3062
Transaction ID From Hibernate :: 3062

Transaction ID From JDBC :: 3062
Transaction ID From JDBC :: 3063

Any ideas what is going wrong ?

[Vijitha Kumara]

But when I'm running it thru hibernate the result set is different.

In what way(s) this is different form the normal behavior?

[Ankit V Agrawal]

hibernate was returning the same object 2 times. I found the error, the unique key was wrongly defined!