org.hibernate.QueryException: Not all named parameters have been set + Use of :id

[Jigar Naik]

Hi

I am new to hibernate and was trying to one example

bellow is my method to retrive a unique record based on the id given as parameter.

As you can see inId is the input parameter which i am pasing to my method as parameter.

    
public Module getModule(long inId){
		System.out.println("inId : " + inId);
		Module module = new Module();
		try{
			Session session = HibernateUtil.beginTransaction();
			Query queryResult = session.createQuery("from Module where id = :inId");
			module = (Module)queryResult.uniqueResult();
			HibernateUtil.commitTransaction();
		}catch(Exception e){
			e.printStackTrace();
		}
		return module;
	}

But while executing this method i am getting following error.
Bellow is the complete stack trace

    
inId : 46
org.hibernate.QueryException: Not all named parameters have been set: [inId] [from Module where id = :inId]
	at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:291)
	at org.hibernate.impl.AbstractQueryImpl.verifyParameters(AbstractQueryImpl.java:275)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:75)
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
	at com.interactcrm.module.ModuleDAO.getModule(ModuleDAO.java:45)
	at com.interactcrm.module.ModuleDAO.main(ModuleDAO.java:58)

What is the use of :inId

can't i write my query as

Query queryResult = session.createQuery("from Module where id = " + inId);

Through this also i can pass the dynamic value right ?

Then what is special about :inId ? Is there any other advantage ?

[Jigar Naik]

All right i got it.

I miss to set the value of inId

queryResult.setLong("inId",inId);

[Bhagat Singh Rawat]

Jigar Naik wrote:All right i got it.

I miss to set the value of inId

queryResult.setLong("inId",inId);

Good catch finally yourself.