Strange behaviour of Native Query

[Ankit Garg]

Well I am using a complicated native query. Because of some sort of performance enhancements, EJB is giving me wrong result in that. First let me explain what the query looks like (I'm giving a simplified version of my query. I had to use native query because I had to group my results month wise)

select t1.name, t2.name
from Payment as p
JOIN User as t1 on p.toId = t1.id
JOIN User as t2 on p.fromId = t2.id

Now I don't know why, it returns the same value for both the columns. I'm sure this is some sort of short cut used by JPA to use a cached version of the value for the second column as both the columns have the same. Although I've solved it by usin SqlResultSetMapping in Payment entity and modifying the query

select t1.name as name1, t2.name as name2
from Payment as p
JOIN User as t1 on p.toId = t1.id
JOIN User as t2 on p.fromId = t2.id

Payment.java

@SqlResultSetMapping(name="QueryName",
                     columns={
                            @ColumnResult(name=name1),
                            @ColumnResult(name=name2)
                     })

Still if there is a way to correct this, then please tell me.

Thanks