Parameter value [0] did not match expected type [java.lang.Integer]

Question

Fun issue where I'm passing an int in and it's complaining about it not matching the type:

org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [0] did not match expected type [java.lang.Integer]

@Procedure(procedureName = "dbo.do_cool_stuff_to_client")
void coolClientStuff(int clientId);

It's being called like so:

public void someOtherMethod(int clientId){
  clientRepository.coolClientStuff(clientId);
}

Answer 1

It turns out there is something stupid/funky with it, where it really wants me to put in the class type and not a primitive type.

Changing the method signature to use Integer instead of int fixed it.

@Procedure(procedureName = "dbo.do_cool_stuff_to_client")
void coolClientStuff(Integer clientId);