Hibernate how to update only one colum value

I need to update only one value in a table through hibernate, the problem is when i try to update only on column in table then i got exception

org.hibernate.HibernateException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	com.seantech.Dao.AbstractDao.handleException(AbstractDao.java:169)
	com.seantech.Dao.AbstractDao.Update(AbstractDao.java:102)
	com.seantech.Dao.DyeDao.returnDye(DyeDao.java:56)
	com.seantech.Actions.DyeAction.ReturnDye(DyeAction.java:72)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:585)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
	org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
	org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

and if i set all the value of the columns then it works.
Can any aboy help how can i update onlu one value in table row.

Normally, if Hibernate is managing the object and you change one property, the update statement only updates that one field.

Now the error you are getting, I don't think it is because of Hibernate trying to update more fields, it sounds more like either database corruption, like the update statement failed because it updated no records cause it couldn't find a record or more. Or even if it is that it could be the mapping is incorrect for the @Id.

Can you post the mapping for that one class that you are trying to update?

Mark

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="com.seantech.Model.DyeCirculation" table="ivt_dies_circulation" >
        <id name="dyeCirId" type="java.lang.Integer">
            <column name="dies_cir_Id" />
            <generator class="increment" />
        </id>
        <property name="empId" type="java.lang.Integer">
            <column name="emp_Id" length="45" />
        </property>
        <property name="dyeId" type="java.lang.String">
            <column name="die_Id" length="45" />
        </property>
        <property name="issueDate" type="timestamp">
            <column name="date" length="45" />
        </property>
        <property name="issuer" type="java.lang.String">
            <column name="Issued_by" length="45" />
        </property>
        <property name="returnDate" type="timestamp">
            <column name="return_date" length="45" />
        </property>
        <property name="rcvBy" type="java.lang.String">
            <column name="rcvd_by" length="45" />
        </property>
    </class>
</hibernate-mapping>

public class DyeCirculation implements java.io.Serializable{
	
	private int dyeCirId;
	private int empId;
	private String dyeId;
	private Date issueDate;
	private String issuer;
	private Date returnDate;
	private String rcvBy;
	
	public DyeCirculation(){
		
	}

public int getDyeCirId() {
		return dyeCirId;
	}

public void setDyeCirId(int dyeCirId) {
		this.dyeCirId = dyeCirId;
	}

public int getEmpId() {
		return empId;
	}

public void setEmpId(int empId) {
		this.empId = empId;
	}

public String getDyeId() {
		return dyeId;
	}

public void setDyeId(String dyeId) {
		this.dyeId = dyeId;
	}

public Date getIssueDate() {
		return issueDate;
	}

public void setIssueDate(Date issueDate) {
		this.issueDate = issueDate;
	}

public String getIssuer() {
		return issuer;
	}

public void setIssuer(String issuer) {
		this.issuer = issuer;
	}

public Date getReturnDate() {
		return returnDate;
	}

public void setReturnDate(Date returnDate) {
		this.returnDate = returnDate;
	}

public String getRcvBy() {
		return rcvBy;
	}

public void setRcvBy(String rcvBy) {
		this.rcvBy = rcvBy;
	}

}

OK, well that is really simple mapping there, and it all looks very good. So I guess that is not the problem.

Now the question is what is the update statement that it is running.

In your session factory configuration you can add the property hibernate.show_sql = true so that the statements are displayed iin your console to see the query. The other thing to figure out is what is the constraint that it is violating? What constraints are on the table besides the PK?

Mark

In the error message, I see DyeDao, and you are updating DyeCirculation? So, I agree with Mark, it is probably the FK to this table which is missing. Maybe you need a one-to-many and many-to-one mapping added to these 2 classes.

Thank you both , for the reply , now the query tells that it tries to update every field generated at console. that is why it generates the constraint violation error as emp_id is FK.
here is query!!!

now how can i update only one column in table ?

Try setting not-null="false" for those values in your table which are not required by the database. I can't remember offhand whether it defaults to true or false, but we always set ours, one way or another.

If that doesn't help, please post the code where you are trying to update. It should be something like this:

Also, if you have a Dye class, and Dye.id = die_id in DyeCirculation class, then you should have a foreign key mapping in your DyeCirculation.hbm.xml, or the database will not save/update/cascade in the way you intend. Also, you will not be using Hibernate to the extent of its performance-enhancing abilities.

Also, try looking here Hibernate Mapping Cheat Sheet
or here Hibernate Common Problems FAQ