| Author |
org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [1]
|
subodh joshi
Greenhorn
Joined: Apr 09, 2010
Posts: 5
|
|
i am using Named Query in my Project Like this
Query query = session.getNamedQuery("selectedPortfolioInfo");
query.setInteger(0, portfolioId);
query.setInteger(0, userID);
List getData = query.list();
and *.hbm.xml file entry is like this
<query name="selectedPortfolioInfo">from PfPortfolioInfo Where id.pfpiId=? And id.umulUserId=? </query>
But i am getting Exception
org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [1]
Both id.pfpiId And id.umulUserId both are composite key columns in database table
Thanks For help
|
 |
Amit Vinod Dali
Ranch Hand
Joined: Apr 14, 2010
Posts: 42
|
|
Please check the positions of the parameters you are passing;
query.setInteger(0, portfolioId);
query.setInteger(0, userID); query.setInteger(1, userID);
|
 |
subodh joshi
Greenhorn
Joined: Apr 09, 2010
Posts: 5
|
|
Sorry i was wrong and wasted the group members time in the simple issue..
thanks again
|
 |
 |
|
|
subject: org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [1]
|
|
|