How to disable spring-jpa automatic method derivation

spring-jpa-disable-automatic-method-derivation.kt

interface UserRepository : JpaRepository<User, Long>, UserRepositoryExtension

interface UserRepositoryExtension {
  /*
   * Here we get exception as following:
   *
   * Caused by: java.lang.IllegalArgumentException: Failed to create query for method 
   *   public abstract User UserRepositoryExtension.getByRoleCriteria(java.lang.String,java.util.Set)!
   *     At least 2 parameter(s) provided but only 1 parameter(s) present in query.
   *
   *   at org.springframework.data.jpa.repository.query.PartTreeJpaQuery.<init>(PartTreeJpaQuery.java:84)
   *   ... <14 internal calls>
   *   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.mapMethodsToQuery(RepositoryFactorySupport.java:561)
   *   ... <11 internal calls>
   *   ... 31 common frames omitted
   * Caused by: java.lang.IllegalArgumentException: At least 2 parameter(s) provided but only 1 parameter(s) present in query.
   *   at org.springframework.util.Assert.isTrue(Assert.java:136)
   *   at org.springframework.data.jpa.repository.query.QueryParameterSetterFactory$CriteriaQueryParameterSetterFactory.create(QueryParameterSetterFactory.java:291)
   *   ... <25 internal calls>
   *   ... 57 common frames omitted
   *
   * This error is fixed when we name this method as `getByNameAndRoles`, but we do not want that.
   *
   * Spring Automatic name derivation rule:
   * https://docs.spring.io/spring-data/jpa/docs/2.0.7.RELEASE/reference/html/#repositories.query-methods.query-creation
   */
  @Nullable
  fun getByRoles(name: String, roles: Set<Role>): User?
}

@Repository
class UserRepositoryExtensionImpl : UserRepositoryExtension {
  @PersistenceContext
  private lateinit var em: EntityManager

  override fun getByRoles(name: String, roles: Set<Role>): User? {
    val roles = roles.map { "\'${it.name}\'" }.joinToString()
    val sql = """
      SELECT u
      FROM User u
      WHERE u.name = $name
        AND u.roles IN ($roles)
    """
    TODO("Not implemented")
  }
}