JPA select query with multiple values

Question

select s.id,s.a.id,s.siteName from site  s where s.a.id=:b

I cannot execute this statement.

ERROR:
Cannot create TypedQuery for query with more than one return using requested result type [com.a.b.entity.site]

I used native query for this. i stored the list of object as follows .. "List<Object[]> obj = Repository.findId(Id); " and i tried to get the values but it didint work. "Site site; for (Object[] object : obj) { site = new Site(); site.setSiteId(Integer.parseInt(object[0]))); } . is there any other way make an object to integer — Tom jaison
– Tom jaison, Commented Sep 27, 2016 at 11:15

Abhishek Ramachandran · Accepted Answer · 2016-09-27 12:44:38Z

2

Workaround for your sub question: use these to convert to integer new Integer((int) object[0])

answered Sep 27, 2016 at 12:44

1,1701 gold badge14 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1