update query fired by hibernate!!!!

[ved gunjan]

hi all,
I'm novice to the hibernate world...i've a simple application wherein i've <many-to-one relation between two valueobject.
Below is my .hbm.xml file.

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

<hibernate-mapping>
<class name="com.manheim.cis.business.contact.beans.EntityAddressVO"
table="ENTADDR">
<composite-id >
<key-property name="entityId" column="ENT_ID" />
<key-property name="addrId" column="ADDR_ID" />
</composite-id>
<property name="addrType" column="ADDR_TYPE" />
<property name="effectiveDate" column="EFFECTIVE_DATE" />
<property name="businessUse" column="BUSINESS_USE" />
<property name="instruction" column="DELIVERY_INSTRUCTION" />
<property name="defaultAddr" column="DEFAULT_ADDR" />
<property name="optOutDate" column="OPT_OUT_DATE" />
<property name="optOutMethod" column="OPT_OUT_METHOD" />
<property name="optOutRequester" column="OPT_OUT_REQUESTER" />
<property name="expireDate" column="EXPIRE_DATE" />
<property name="createdDate" column="CREATE_DATE" />
<property name="createdBy" column="CREATE_BY" />
<property name="updatedTime" column="UPDATE_TIME" />
<property name="updatedBy" column="UPDATE_BY" />
<many-to-one name="addressVO" column="ADDR_ID"
class="com.manheim.cis.business.contact.beans.AddressVO"
insert="false" update="false" cascade="all">
</many-to-one>
</class>
<class name="com.manheim.cis.business.contact.beans.AddressVO"
table="ADDR">
<id name="addrId" column="ADDR_ID" unsaved-value="null" >
<generator class="increment"></generator>
</id>
<property name="addr1" column="ADDR1" />
<property name="addr2" column="ADDR2" />
<property name="city" column="CITY" />
<property name="county" column="COUNTY" />
<property name="state" column="STATE" />
<property name="zip" column="ZIP_CODE" />
<property name="countryName" column="COUNTRY_NAME" />
<property name="countryCode" column="COUNTRY_CODE" />
<property name="latitude" column="LATITUDE" />
<property name="longtitude" column="LONGITUDE" />
<property name="timeZone" column="TIMEZONE" />
<property name="createdDate" column="CREATE_DATE" />
<property name="createdBy" column="CREATE_BY" />
</class>
</hibernate-mapping>


This is the hibernate generated query:
insert into ADDR (ADDR1, ADDR2, CITY, COUNTY, STATE, ZIP_CODE, COUNTRY_NAME, COUNTRY_CODE, LATITUDE, LONGITUDE, TIMEZONE, CREATE_DATE, CREATE_BY, ADDR_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

insert into ENTADDR (ADDR_TYPE, EFFECTIVE_DATE, BUSINESS_USE, DELIVERY_INSTRUCTION, DEFAULT_ADDR, OPT_OUT_DATE, OPT_OUT_METHOD, OPT_OUT_REQUESTER, EXPIRE_DATE, CREATE_DATE, CREATE_BY, UPDATE_TIME,

UPDATE_BY, ENT_ID, ADDR_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
update ADDR set ADDR1=?, ADDR2=?, CITY=?, COUNTY=?, STATE=?, ZIP_CODE=?, COUNTRY_NAME=?, COUNTRY_CODE=?, LATITUDE=?, LONGITUDE=?, TIMEZONE=?, CREATE_DATE=?, CREATE_BY=? where ADDR_ID=?


My doubt is why hibernate is going for an update operation in to ADDR table after doing a insert in ADDR table and how to prevent it.
I've tried with all the possible combination of unsaved-value attributes in both the valueobjects/tables.

Also please can any one cleary explain the meaning of unsaved-value attributes and its possible values and how it is realted to the object beign persisted.

Thanx in advance for any kind of help!!!

Regards
Ved

[rachit gupta]

Set Not-null to True in Many-to-one tag first....
id field and column name in many-to-one should be different.
then only u can avoid update query

[Marcel Jacome]

I have the same problem , this is my code , hibernate is performing an unnecessary update , an giving me this error message.

Hibernate operation: Could not execute JDBC batch update; bad SQL grammar [/* update ec.gov.iess.modelo.fondoreserva.Calificacion */ update FRAFITACTCES set CREMORHPHL=? where CEDULA=?]; nested exception is java.sql.BatchUpdateException: ORA-01031: insufficient privileges ".


this is my the entity code:

   

/**
 * Proposito:
 * 
 * @author 
 * @date 10-oct-2005 *
 * @hibernate.class table="FRAFITACTCES" dynamic-update="true"
 *                  dynamic-insert="true" lazy="true"
 * @hibernate.query name="Calificacion.seleccionarConPostfijo" query="from
 *                  Calificacion o where o.cedula like :postfijo "
 *                  
 * 
 */
public class Calificacion {
	public static final String ESTADO_ACTIVO = "ACT";

	public static final String ESTADO_CESANTE = "CES";

	public static final String ESTADO_NOEXISTE = "NE";

	public static final String SI_MORA_CREDITO = "1";

	public static final String NO_MORA_CREDITO = "0";

	public static final String SI_MORA_PATRONAL = "1";

	public static final String NO_MORA_PATRONAL = "0";

	public static final String SI_FALLECIDO = "1";

	public static final String NO_FALLECIDO = "0";

	public static final String SI_MAYOR_EDAD = "1";

	public static final String NO_MAYOR_EDAD = "0";

	public static final String SI_MORA_CREDITO_HL = "1";

	public static final String NO_MORA_CREDITO_HL = "0";

	public static final String SI_MORA_CREDITO_HOST = "1";

	public static final String NO_MORA_CREDITO_HOST = "0";

	public static final String SI_CREDITO_ESPECIAL = "1";

	public static final String NO_CREDITO_ESPECIAL = "0";
	
	public static final String SI_MORA_HIPOTECARIO_HL = "1";

	public static final String NO_MORA_HIPOTECARIO_HL = "0";

	private String cedula;

	private String estadoHistoriaLaboral;

	private String estadoHost;

	private String estadoResultado;

	private String estadoMoraCreditoHistoriaLaboral;

	private String estadoMoraCreditoHost;

	private String estadoMoraPatronal;
	
	private String estadoMoraCreditoHipotecario;

	private String estadoFallecido;

	private String estadoJubilado;

	private String estadoCreditoEspecial;

	private String mayorEdad;

	private String estadoActualHistoriaLaboral;

	/**
	 * @return Returns the cedula.
	 * @hibernate.id column="CEDULA" generator-class="assigned"
	 */
	public String getCedula() {
		return cedula;
	}

	/**
	 * @return Returns the estadoHistoriaLaboral.
	 * @hibernate.property column="ESTHL" not-null="true"
	 */
	public String getEstadoHistoriaLaboral() {
		return estadoHistoriaLaboral;
	}

	/**
	 * @return Returns the estadoHost.
	 * @hibernate.property column="ESTHOST" not-null="true"
	 */
	public String getEstadoHost() {
		return estadoHost;
	}

	/**
	 * @param cedula
	 *            The cedula to set.
	 */
	public void setCedula(String cedula) {
		this.cedula = cedula;
	}

	/**
	 * @param estadoHistoriaLaboral
	 *            The estadoHistoriaLaboral to set.
	 */
	public void setEstadoHistoriaLaboral(String estadoHistoriaLaboral) {
		this.estadoHistoriaLaboral = estadoHistoriaLaboral;
	}

	/**
	 * @param estadoHost
	 *            The estadoHost to set.
	 */
	public void setEstadoHost(String estadoHost) {
		this.estadoHost = estadoHost;
	}

	/**
	 * @return Returns the estadoResultado.
	 */
	public String getEstadoResultado() {
		return estadoResultado;
	}

	/**
	 * @param estadoResultado
	 *            The estadoResultado to set.
	 */
	public void setEstadoResultado(String estadoResultado) {
		this.estadoResultado = estadoResultado;
	}

	/**
	 * @return Returns the estadoFallecido.
	 * @hibernate.property column="FALLECIDO" not-null="false"
	 */
	public String getEstadoFallecido() {
		return estadoFallecido;
	}

	/**
	 * @return Returns the estadoMoraCreditoHistoriaLaboral.
	 * @hibernate.property column="CREHL" not-null="false"
	 */
	public String getEstadoMoraCreditoHistoriaLaboral() {
		return estadoMoraCreditoHistoriaLaboral;
	}

	/**
	 * @return Returns the estadoMoraCreditoHost.
	 * @hibernate.property column="CREHOST" not-null="false"
	 */
	public String getEstadoMoraCreditoHost() {
		return estadoMoraCreditoHost;
	}

	/**
	 * @return Returns the estadoMoraPatronal.
	 * @hibernate.property column="CREPAT" not-null="false"
	 */
	public String getEstadoMoraPatronal() {
		return estadoMoraPatronal;
	}

	/**
	 * @param estadoFallecido
	 *            The estadoFallecido to set.
	 */
	public void setEstadoFallecido(String estadoFallecido) {
		this.estadoFallecido = estadoFallecido;
	}

	/**
	 * @param estadoMoraCreditoHistoriaLaboral
	 *            The estadoMoraCreditoHistoriaLaboral to set.
	 */
	public void setEstadoMoraCreditoHistoriaLaboral(String estadoMoraCreditoHistoriaLaboral) {
		this.estadoMoraCreditoHistoriaLaboral = estadoMoraCreditoHistoriaLaboral;
	}

	/**
	 * @param estadoMoraCreditoHost
	 *            The estadoMoraCreditoHost to set.
	 */
	public void setEstadoMoraCreditoHost(String estadoMoraCreditoHost) {
		this.estadoMoraCreditoHost = estadoMoraCreditoHost;
	}

	/**
	 * @param estadoMoraPatronal
	 *            The estadoMoraPatronal to set.
	 */
	public void setEstadoMoraPatronal(String estadoMoraPatronal) {
		this.estadoMoraPatronal = estadoMoraPatronal;
	}

	/**
	 * @return Returns the estadoJubilado.
	 * @hibernate.property column="ESTJUB" not-null="false"
	 */
	public String getEstadoJubilado() {
		return estadoJubilado;
	}

	/**
	 * @param estadoJubilado
	 *            The estadoJubilado to set.
	 */
	public void setEstadoJubilado(String estadoJubilado) {
		this.estadoJubilado = estadoJubilado;
	}

	/**
	 * @return Returns the estadoJubilado.
	 * @hibernate.property column="CREZ1" not-null="false"
	 */
	public String getEstadoCreditoEspecial() {
		return estadoCreditoEspecial;
	}

	public void setEstadoCreditoEspecial(String estadoCreditoEspecial) {
		this.estadoCreditoEspecial = estadoCreditoEspecial;
	}

	/**
	 * @return Returns the mayorEdad.
	 * @hibernate.property column="EDAD" not-null="false"
	 */
	public String getMayorEdad() {
		return mayorEdad;
	}

	public void setMayorEdad(String mayorEdad) {
		this.mayorEdad = mayorEdad;
	}

	/**
	 * @return Returns the cedula.
	 * @hibernate.property column="ESTHLACT" not-null = "false"
	 */
	public String getEstadoActualHistoriaLaboral() {
		return estadoActualHistoriaLaboral;
	}

	public void setEstadoActualHistoriaLaboral(String estadoActualHistoriaLaboral) {
		this.estadoActualHistoriaLaboral = estadoActualHistoriaLaboral;
	}
	
	/**
	 * @return Returns the estadoMoraCreditoHipotecario.
	 * @hibernate.property column="CREMORHPHL" not-null = "false"
	 */
	public void setEstadoMoraCreditoHipotecario(
			String estadoMoraCreditoHipotecario) {
		this.estadoMoraCreditoHipotecario = estadoMoraCreditoHipotecario;
	}

	public String getEstadoMoraCreditoHipotecario() {
		  return estadoMoraCreditoHipotecario;
	}
}

I started getting this error after adding a new private member and its setter and getter

  	/**
	 * @return Returns the estadoMoraCreditoHipotecario.
	 * @hibernate.property column="CREMORHPHL" not-null = "false"
	 */
	public void setEstadoMoraCreditoHipotecario(
			String estadoMoraCreditoHipotecario) {
		this.estadoMoraCreditoHipotecario = estadoMoraCreditoHipotecario;
	}

	public String getEstadoMoraCreditoHipotecario() {
		  return estadoMoraCreditoHipotecario;
	}  

I will greatly appreciate your help

[Bear Bibeault]

Rather than tack your question onto an old post, it'd be better in the future if you start a new post. Please read this for more information.