how to get list of long values in hibernate from the table while casting from bigint to long

Question

I get the following exception when using the getEvents method:

org.hibernate.MappingException: Unknown entity: java.lang.Long

public List<Long> getEvents(Person person) {

    String q = "select new java.lang.Long(te.event_id) "
        + "from teachers_event te"
        + "where te.teachers_id = :personId ";
    Query query = entityManager.createNativeQuery(q, Long.class);
    query.setParameter("personId", person.getId());
    return (List<Long>) query.getResultList();
}

The teachers_event table in database connects the id of teacher with the event. I don't map this table to an entity. I only want to get the ids from it. The ids in the PostgreSQL table are bigint. Is there any way to achieve it without making a separate class to map the TeacherEvents entity?

What is the exception?

Jure
– Jure

2017-12-04 09:00:48 +00:00
Commented Dec 4, 2017 at 9:00 — Jure
– Jure, Commented Dec 4, 2017 at 9:00
updated the exception

krltos
– krltos

2017-12-04 09:02:08 +00:00
Commented Dec 4, 2017 at 9:02 — krltos
– krltos, Commented Dec 4, 2017 at 9:02

Maciej Kowalski · Accepted Answer · 2017-12-04 09:24:14Z

1

In JPA 2.1 there is a feature called "result set mapping".

Basically you have to define a POJO class which would hold the result values (all the values must be passed using the constructor):

public class IdResult{

    private Object id;

    public IdResult(Object id){
        this.id = id;
    }

     public Long getLongId(){
        return (Long)id;
     }
}

Then you have to declare the mapping on one of your entities (does not matter on which, it just has to be a declated @Entity):

@SqlResultSetMapping(name="IdMapping", classes = {
    @ConstructorResult(targetClass = IdResult.class, 
    columns = {@ColumnResult(name="id")})
})

You would have to use an alias in your query to match the @ColumnResult name:

select te.event_id as id
...

And finally use in the query creation:

Query query = entityManager.createNativeQuery(q, IdMapping.class);
return (List<IdResult>) query.getResultList();

Then in your service layer you would just use getLongId();

answered Dec 4, 2017 at 9:24

Maciej Kowalski

26.7k12 gold badges59 silver badges66 bronze badges

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

5 Comments

krltos Over a year ago

I accept the answer as it solves the case, however, I was hoping that there is a way to avoid the result set mapping in this particular case.

Maciej Kowalski Over a year ago

would be possible with a standard jpa query, but native queries do not have the direct resultClass in the creation method unfortunatelly.

krltos Over a year ago

how would the standard jpa query look like?

Maciej Kowalski Over a year ago

you would need to map the table as an entity.. but i think that is what you want to ommit

krltos Over a year ago

Yeah, exactly I wanted to avoid the creation of the entity for the table. Finally, I changed the List to store BigIntegers instead of Longs, so that it matches the database schema which I couldn't modify. That way no need for the casting in the query.

Collectives™ on Stack Overflow

how to get list of long values in hibernate from the table while casting from bigint to long

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related