Using named parameters for method when I use @Query

Question

I am using spring-data-jpa, I want update something, I have annotated my method in PaySupplierSettleBillRepository as

public interface PaySupplierSettleBillRepository extends JpaRepository<PaySupplierSettleBillEntity, Long>,
        JpaSpecificationExecutor<PaySupplierSettleBillEntity> {

    @Modifying
    @Query("update PaySupplierSettleBillEntity p set p.payTime=:payTime,p.paymentOrder=:paymentOrder, p.transferTime=:transferTime, p.transferBank=:transferBank, p.transferOrder=:transferOrder, p.operatorName=:operatorName, p.remark=:remark where p.orderNumber=:orderNumber")
    int updatePayInfo(PaySupplierSettleBillEntity entity);
}

I am getting following exception while starting

Caused by: java.lang.IllegalStateException: Using named parameters for method public abstract xxxxxx

how I fix it ? thinks.

I don't want use ` Custom Implementations for Spring Data Repositories` way — abyss lee
– abyss lee, Commented May 9, 2019 at 6:10

Mr.J4mes · Accepted Answer · 2019-05-09 06:16:45Z

5

That is not how you write a @Query with named parameters. Take a look at the example from Spring documentation here (https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#jpa.named-parameters).

If you want to provide an object as param, you can do something like this.

@Query("UPDATE Entity E SET E.name = :#{#entity.name}")
public void updateEntity(@Param("entity") Entity entity);

answered May 9, 2019 at 6:16

Mr.J4mes

9,28412 gold badges51 silver badges92 bronze badges

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

1 Comment

Satish Patro Over a year ago

This is awesome

Justinas Jakavonis · Accepted Answer · 2022-02-02 21:02:14Z

3

Caused by: java.lang.IllegalStateException: Using named parameters for method can be thrown when a method has redundant parameter which is not used in the @Query.

In your case, entity should be used in the SQL query like it's mentioned in the previous answer https://stackoverflow.com/a/56053250/5962766 or you should replace it with specifying necessary parameters one by one in the method signature.

Related: IllegalStateException with naming parameters in tomcat

edited Feb 2, 2022 at 21:02

answered Feb 2, 2022 at 20:40

Justinas Jakavonis

8,95812 gold badges82 silver badges118 bronze badges

1 Comment

Gopal Singh Sirvi Over a year ago

<3. In my case one of the parameter was not used in the query

Collectives™ on Stack Overflow

Using named parameters for method when I use @Query

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related