Spring Data JPA ClassCastException: Integer cannot be cast to Long

Question

In my Spring Data application I ran into the similar problem described here ClassCastException: Integer cannot be cast to Long, while trying to iterate over entity IDs

This my entity:

@Table(name = "users")
public class User extends BaseEntity implements Serializable {

    private static final long serialVersionUID = 5088960286161030648L;

    @Id
    @SequenceGenerator(name = "users_id_seq", sequenceName = "users_id_seq", allocationSize = 1)
    @GeneratedValue(strategy = GenerationType.AUTO, generator = "users_id_seq")
    private Long id;
...
}

and Spring Data Repository method:

@Query(value = "SELECT u.user_id FROM users u WHERE u.game_id =:gameId", nativeQuery = true)
List<Long> getGameIds(@Param("gameId") Long gameId);

which is going to return List of Long type but after execution returns List of Integer and application fails with

java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long

How to tell Spring Data or JPA return List of Long(not Integer) in the result list ?

I don't want to cast values(Integer to Long) in run-time.

Also, the main criterion of my application is performance so is it a good idea to switch my IDs from Long to Integer in all my entities ? Is it a good practice to use Integer instead of Long in JPA for entity ID ?

UPDATED

I use PostgreSQL

In case of:

user_id INTEGER I'm receiving - java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long

user_id BIGINT I'm receiving - java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

Did you try to use not native query but JPQL, something like "select id from User where ..."? — Stan
– Stan, Commented May 9, 2016 at 9:00
Check the database type of the column for entityId, use appropriate type for column and compatible type for attribute in java class, then this won't appear. — Bilbo Baggins
– Bilbo Baggins, Commented May 9, 2016 at 9:01
I'm using PostgreSQL. I have updated my question and added more info about my user_id datatype. — alexanoid
– alexanoid, Commented May 9, 2016 at 9:20
@Stan, JPQL works fine, thanks ! Is any chance to get it working with a native query also ? — alexanoid
– alexanoid, Commented May 9, 2016 at 9:32

asm0dey · Accepted Answer · 2016-05-10 05:32:50Z

3

Problem is when you are using native query Long class doesn't corellate with your database type — getLong doesn't work there. So you should do one of the following

Change type in db and in app to BigInteger (if integer is not enough for your needs)
Change type in db and in app to Integer (if it's enough for your needs)
Remove nqtiveQuery attribute and use clear JPQL.

answered May 10, 2016 at 5:32

asm0dey

2,9492 gold badges23 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Spring Data JPA ClassCastException: Integer cannot be cast to Long

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related