java.lang.IllegalStateException: Using named parameters

Question

when i use this query then always show error why? am using MappedSuperclass in audit class.

@Query("select new  com.brite.domain.CurrencyConversion(ins.id,ins.contractType,ins.symbol,ins.exchange,ins.currency,ap.allocationQty,ap.createdDate,ca.baseCurrency,hd.close) from ActualPortfolio as ap JOIN  Instrument as ins on ins.id=ap.instrument.id JOIN  HistoricalData as hd on hd.instrumentId = ins.id   Join ClientAccount as ca on ca.accountId = ap.clientAccount.accountId  where ap.clientAccount.accountId =:accountId and ap.createdDate = (select MAX(pf.createdDate) as date from ActualPortfolio pf where  ap.clientAccount.accountId =:accountId and pf.createdDate =: createdDate) and hd.dateTime = (select to_char(MAX(pf.createdDate), 'YYYY-MM-DD 00:00:00') as date from ActualPortfolio pf where  ap.clientAccount.accountId =:accountId and pf.createdDate =: createdDate)")

Pojo class looks

        @Entity
        @EntityListeners(AuditingEntityListener.class)
        public class Transaction extends Audit {    
            private Long Id;     

        }

and audit class is

        @MappedSuperclass
        public class Audit {

            @Column(name = "createdDate", columnDefinition = "TIMESTAMP WITH TIME ZONE")
            @CreatedDate
            @JsonSerialize(using = CustomDateSerializer.class)
            private LocalDateTime createdDate;

        }

Caused by: java.lang.IllegalStateException: Using named parameters for method public abstract java.util.List com.brite.repository.InstrumentRepository.getInstrumentForCurrencyConverstion(java.lang.String,java.time.LocalDateTime) but parameter 'Optional[createdDate]' not found in annotated query 'select new com.brite.domain.CurrencyConversion(ins.id,ins.contractType,ins.symbol,ins.exchange,ins.currency,ap.allocationQty,ap.createdDate,ca.baseCurrency,hd.close) from ActualPortfolio as ap JOIN Instrument as ins on ins.id=ap.instrument.id JOIN HistoricalData as hd on hd.instrumentId = ins.id Join ClientAccount as ca on ca.accountId = ap.clientAccount.accountId where ap.clientAccount.accountId =:accountId and ap.createdDate = (select MAX(pf.createdDate) as date from ActualPortfolio pf where ap.clientAccount.accountId =:accountId andenter code here pf.createdDate =: createdDenter code hereate) and hd.dateTime =enter code here (select to_char(MAX(pf.createdDate), 'YYYY-MM-DD 00:00:00') as date from ActualPortfolio pf where ap.clientAccount.accountId =:accountId and pf.createdDate =: createdDate)'!

Maybe your repository parameter createdDate does not have annotation @Param("createdDate") or parameter name differ from name in hql — Oleksii Valuiskyi
– Oleksii Valuiskyi, Commented Jul 19, 2019 at 10:19
As mentioned in below answer, you are using optional created date as parameter. Change it to allow the unwrapped date object. But yiu haven't posted your java part of code. So please correct your question for people to help you. — Karthik R
– Karthik R, Commented Jul 19, 2019 at 10:46
You 'd better remove constructions like "from ActualPortfolio as ap JOIN Instrument as ins on ins.id=ap.instrument.id". You can use "from ActualPortfolio ap JOIN ap.instrument ins" or "from ActualPortfolio ap, Instrument ins where ins.id=ap.instrument.id" instead — Oleksii Valuiskyi
– Oleksii Valuiskyi, Commented Jul 19, 2019 at 13:28

raja yadav · Accepted Answer · 2019-07-23 10:13:01Z

4

thanx, something was wrong with my query. we don't need to put space after colon ':' in query

answered Jul 23, 2019 at 10:13

raja yadav

511 gold badge1 silver badge7 bronze badges

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

Comments

acteon · Accepted Answer · 2019-07-19 10:40:49Z

2

It seems to me you are passing Optional Argument to method. That might be causing problems.

answered Jul 19, 2019 at 10:40

acteon

4293 silver badges7 bronze badges

Comments

Jhansi · Accepted Answer · 2022-10-17 06:30:45Z

0

verify Method parameter names with Query dynamic parameter names. if both are same it will work.

EX:

answered Oct 17, 2022 at 6:30

Jhansi

1

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

flyingfishcattle · Accepted Answer · 2023-04-03 18:15:18Z

0

This problem can occur when the parameter name has a mismatch with the variable name.

edited Apr 3, 2023 at 18:15

flyingfishcattle

2,2213 gold badges19 silver badges31 bronze badges

answered Mar 28, 2023 at 4:52

Sheikh Shahinur Rahman Shawon

11 bronze badge

Collectives™ on Stack Overflow

java.lang.IllegalStateException: Using named parameters

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related