Hibernate native query return List Object List

Question

I am using an hibernate NQL query which fetches me two columns :

SELECT object_name, 
       object_name_location 
FROM   dbo.object_stacks 
WHERE  object_id IN (SELECT thumb_nail_obj_id 
                     FROM   dbo.uois 
                     WHERE  Upper(NAME) LIKE Upper('%testobj%'))

When I select only one column i.e only object name - everything works fine but with two columns I am getting an error

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.lang.String

at run time when I try to display result from the list. I tried using String array in the list as well but it doesn't work. Below are my code snippets which give error :

When I use only List :

List<String> Thumbnailpaths = pathquery.list();
System.out.println(Thumbnailpaths.get(i).replace("\\", "\\\\"));

No error at compile time also nothing if leave it as it is but above line to display gives classcast exception.

When I use List array :

List<String[]> Thumbnailpaths = pathquery.list();

System.out.println(Thumbnailpaths.get(i)[0].replace("\\", "\\\\"));

Here again classcast exception at runtime

Also Criteria.ALIAS_TO_ENTITY_MAP doesn't help at all as it makes logic much more complex. I just need 2 column values from a database table.

Please let me know if there is any solution to fetch multiple column results in NQL and then put in list.

Note : Looks like here generics are not displaying and only List is being written in my code snippet

The query returns List<Object[]> (not List<String[]>) as you are trying to return a list of tuples from the database (This is what the exception message means). — Tiny
– Tiny, Commented Sep 9, 2016 at 9:23
got it resolved. I got exact result when I used object array : Object[] data = Thumbnailpaths.get(i); — newuserhibernate
– newuserhibernate, Commented Sep 9, 2016 at 9:30

Abhijeet · Accepted Answer · 2016-09-09 09:32:08Z

2

Unfortunately, Hibernate doesn't provide a standard way to retrieve the results for columns of table and store directly to Entity Object.You have to manually parse the data fetched by your query.

The hibernate query will return List of Object Array i.e. List<Object[]>. Object[] will contain data from your columns. List is nothing but rows retrieved by query. In your case you can refer following code :

List<Object[]> Thumbnailpaths = pathquery.list();
for(Object[] objArr : Thumbnailpaths)
{
    String objName = (String)objArr[0];
    String objNameLocation = (String)objArr[1];
    System.out.println(objName + " : " +objNameLocation);
}

Above code will help you parse the object[]

answered Sep 9, 2016 at 9:32

Abhijeet

4,3491 gold badge26 silver badges42 bronze badges

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

Comments

Liping Huang · Accepted Answer · 2016-09-09 09:14:02Z

0

Yes, hibernate will return the Object arrays (Object[]) for this case - return multiple columns. but you still can using the "Entity queries" to return a entity objects rather then the "raw" value.

edited Sep 9, 2016 at 9:14

answered Sep 9, 2016 at 9:08

Liping Huang

4,4844 gold badges31 silver badges48 bronze badges

1 Comment

newuserhibernate Over a year ago

Got it resolved. I used Object array to fetch list data. for (int i = 0 ; i<Thumbnailpaths.size(); i++) { Object[] data = Thumbnailpaths.get(i);

Collectives™ on Stack Overflow

Hibernate native query return List Object List

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related