File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

org.hibernate.QueryException: Expected positional parameter count: 2, actual parameters: [1]

 
subodh joshi
Ranch Hand
Posts: 56
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 42
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please check the positions of the parameters you are passing;

query.setInteger(0, portfolioId);
query.setInteger(0, userID); query.setInteger(1, userID);

 
subodh joshi
Ranch Hand
Posts: 56
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry i was wrong and wasted the group members time in the simple issue..


thanks again
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic