Parameter value [1] did not match expected type [java.lang.Integer (n/a)]

Question

I have entity and rest controller, when I make a request to my controller it throws this exception:

java.lang.IllegalArgumentException: Parameter value [1] did not match expected type [java.lang.Integer (n/a)]

My controller:

@GetMapping("/createCharacter")
public Character createCharacters(@RequestParam("userId") Integer userId, @RequestParam("mapId") long mapId) {
    return createCharactersService.createCharacters(userId, mapId);
}

My entity has int type id:

  @Id
@GeneratedValue(strategy = GenerationType.AUTO)
private int id;

I tried to change Integer to Long or String it helped to fix my problem but in this case my Spring Data Rest for user entity doesn't work. — gg ff, Apr 12 '19 at 16:18
Why would you declare an Id as a String, is it a uuid? Usually Ids are of type Long in the entity, especially when the the relative id field in database is Big Integer. — Christos Karapapas, Apr 12 '19 at 16:23
Ye, it is UUID. But now i replaced it with primitive numbers. — gg ff, Apr 12 '19 at 16:29

score 6 · Answer 1 · answered Jan 15 '20 at 10:59

For those who find this issue based on the error:

java.lang.IllegalArgumentException: Parameter value [Type@abdc80fc] did not match expected type [Type (n/a)]

You might be using JPA like this:

@Repository
public interface OtherRepository extends JpaRepository<Other, Long> {
    List<Other> findAllByType(final Type type);

In that case, please make use of the id of Type (thus: findAllByTypeId).

score 2 · Accepted Answer · answered Apr 13 '19 at 04:12

Since the Id is a uuid you must keep it as a string in the entity.

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private String id;

Therefore you are bound to use it as a String in Service and in Controller.

@GetMapping("/createCharacter")
public Character createCharacters(@RequestParam("userId") String userId, @RequestParam("mapId") long mapId) {
    return createCharactersService.createCharacters(userId, mapId);
}

score 2 · Answer 3 · answered Dec 17 '20 at 03:27

If you are using JPA with @Query for example :

 @Query("SELECT r FROM Employee r WHERE r.empId = ?1)
 Employee getMyEmployee(long id);

OR

@Query("SELECT r FROM Employee r WHERE r.empId = :id)
Employee getMyEmployee(@Param("id") long id);

Make sure the passing parameter is long value and empId also a long value. If you execute the method classObj.getMyEmployee(someIntVariable) by passing int value it could cause the above error.

score 2 · Answer 4 · answered Jun 04 '21 at 10:00

2

in my case I have used DTOs so

Previously my @query was like this

@query("SELECT ... WHERE ucs.district = ?1")

Then I changed @query like this

@query("SELECT ... WHERE ucs.district.id = ?1")

answered Jun 04 '21 at 10:00

hexhad

1,139
12
14

Parameter value [1] did not match expected type [java.lang.Integer (n/a)]

4 Answers4