Hibernate Community • View topic - Problem when I use parameters into HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem when I use parameters into HQL

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

uzumaki

Post subject: Problem when I use parameters into HQL

Posted: Mon Mar 14, 2011 12:01 pm

Newbie

Joined: Wed Jan 19, 2011 6:25 am
Posts: 2

I am trying to use this query:

Code:

   //Recupero la sessione da Hibernate
      Session session = sessionFactory.getCurrentSession();
      logger.debug("Il nome della licenza e': "+nomelicenza);
      String textQuery = "from Vocelicenza as v where v.voceLicenza = :nomelicenza";
      Query query = session.createQuery(textQuery);
      List<Vocelicenza> listaVocLic = query.list();
      int lastIndex = listaVocLic.size()-1; 
      return listaVocLic.get(lastIndex);
      

where nomelicenza is a String, but when I run my Spring MVC application I obtain the following error:
Not all named parameters have been set: [nomeLicenza] [from Vocelicenza as v where v.voceLicenza = :nomeLicenza]

Top

nordborg

Post subject: Re: Problem when I use parameters into HQL

Posted: Mon Mar 14, 2011 1:26 pm

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

You'll need to set the value of the parameter before executing the query.list() method: