What could the reason of the exception 'org.hibernate.QueryException Message Not all named parameters have been set:' possibly be?

Question

So I am trying to execute the following query in grails

User user = springSecurityService.currentUser
def approverGroupList = approverGroupService.getApproverGroupsByUser(user.id)
return VerificationRequest.executeQuery("select distinct v.fundTransfer from VerificationRequest v where v.fundTransfer.creator.corporateHouse=:corporateHouse and v.verified = false and v.fundTransfer.status ='QUEUED' and v.approverGroup in (:approverGroupList)", [corporateHouse:corporateHouse],[approverGroupList:approverGroupList])

However I am getting the following exception :

/fund-transfer/list-verification-requests
Class
    org.hibernate.QueryException
Message
    Not all named parameters have been set: [approverGroupList] [select distinct v.fundTransfer from VerificationRequest v where v.fundTransfer.creator.corporateHouse=:corporateHouse and v.verified = false and v.fundTransfer.status ='QUEUED' and v.approverGroup in (:approverGroupList)]

Also corporateHouse is an object that's passes to the method executing this query and its not null. What could be the reason?

P.S. I am new to grails!

Let me guess: No all parameters have been set?

isnot2bad
– isnot2bad

2014-08-18 09:30:21 +00:00
Commented Aug 18, 2014 at 9:30 — isnot2bad
– isnot2bad, Commented Aug 18, 2014 at 9:30

Paweł Piecyk · Accepted Answer · 2014-08-18 09:45:07Z

4

You've passed two maps to executeQuery:

VerificationRequest.executeQuery("...", [corporateHouse:corporateHouse],[approverGroupList:approverGroupList])

It should be one map with two values:

VerificationRequest.executeQuery("...", [corporateHouse:corporateHouse, approverGroupList:approverGroupList])

According to documentation the second map was taken as map with additional parameters.

edited Aug 18, 2014 at 9:45

answered Aug 18, 2014 at 9:37

Paweł Piecyk

2,79917 silver badges17 bronze badges

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

Comments

danielkelemen · Accepted Answer · 2014-08-18 09:36:57Z

4

Looks like the parameters should be in one map, like this:

[corporateHouse:corporateHouse, approverGroupList:approverGroupList]

answered Aug 18, 2014 at 9:36

danielkelemen

1,69911 silver badges14 bronze badges

Comments

Mohan Raj B · Accepted Answer · 2014-08-18 09:32:15Z

0

It means that you have not set all the parameters in the query. You have missed some check your query execution code

answered Aug 18, 2014 at 9:32

Mohan Raj B

1,0267 silver badges14 bronze badges

1 Comment

Smrita Over a year ago

Can you point out where ? I see no error to be honest! But ofcourse I am totally new to grails!

Collectives™ on Stack Overflow

What could the reason of the exception 'org.hibernate.QueryException Message Not all named parameters have been set:' possibly be?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related