Record getting inserted instead of update

[Jigar Naik]

Hi i am trying to update record in database using hibernate but intead of updating record one new record is getting inserted.

bellow is my method for update()

public void updateModule(Module inModule) {
		Module module;
		try {
			System.out.println("id : " + inModule.getId());
			System.out.println("code : " + inModule.getCode());
			System.out.println("name : " + inModule.getName());
			Session session = HibernateUtil.beginTransaction();
			Query query = session.createQuery("from Module where id = :id");
			query.setLong("id", inModule.getId());
			module = (Module) query.uniqueResult();
			System.out.println("module : id " + module.getId());
			System.out.println("module : code : " + module.getCode());
			System.out.println("module : name " + module.getCode());
			module.setId(inModule.getId());
			module.setName(inModule.getName());
			module.setCode(inModule.getCode());
			session.update(module);
			HibernateUtil.commitTransaction();
		} catch (Exception e) {
			HibernateUtil.rollbackTransaction();
			e.printStackTrace();
		}
	}

Bellow is my database table

DDL

CREATE TABLE `module` (                                   
          `id` bigint(20) NOT NULL auto_increment,                
          `code` varchar(20) default NULL,                        
          `name` varchar(100) default NULL,                       
          `expiry_date` date default NULL,                        
          PRIMARY KEY  (`id`)                                     
        )

Bellow is my hibernate persistant class

    
package com.interactcrm.module;

import java.io.Serializable;
import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="module", schema="licensemanager")
public class Module implements Serializable{
	
	private Long 	id;
	private String 	code;
	private String 	name;
	private Date 	expiryDate;
	
	@Id
	@GeneratedValue
	@Column (name="id")
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	@Column (name="code")
	public String getCode() {
		return code;
	}
	public void setCode(String code) {
		this.code = code;
	}
	@Column (name="name")
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Column (name="expiry_date")
	public Date getExpiryDate() {
		return expiryDate;
	}
	public void setExpiryDate(Date expiryDate) {
		this.expiryDate = expiryDate;
	}
	
}

[Paul Sturrock]

Why do you use a query to get an entity by its primary key? Its less work to use Session.get or Session.load.

Why do you use uniqueResult when the query is by primary key?

What value does inModule.getId() return?

[Jigar Naik]

yes the id was null.. thanks...

today is my first day to hibernate and get & load is next