Hi guys it is the third time that i try to be answered about that.

I have 3 different and detached objects that comes fron an internet session and add a child for each.
like:

father.addChild(child) {

child.setFather..
father.getChilds.add ..

}

It generates

- One insert and three (in my case), unnecessary updates.
insert Child
update father
update father..

None Father table properties was modified !
Then when i lock, hibernate says that the object is dirty forcing me to update it.

There is a way to avoid this !?


Thanks in advance and sorry by english.

http://www.hibernate.org/ForumMailingli ... AskForHelp



tips: select-before-update, maybe dynamic-update too

Sorry, i thought that my explanation was enough clear.

That is the point, i am trying to avoid unnecessary queries, like that.
Where i do not change any properties to justify , these updates .
Just add a child to a parent , no other property is changed, so the same in the Parents table.
Here goes de xml´s , de objects , and DAO.
Hibernate 2.1.7.
Database Sybase.


One Parent
XML

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="hello.Destino" lazy="true" table="DESTINOS" dynamic-update="true">
<id name="id" column="DESTINO_ID" >
<generator class="increment"/>
</id>
<property name="nome" column="NOME" not-null="true" />
<property name="endereco" column="ENDERECO" not-null="true"/>
<property name="pais" column="PAIS" not-null="true"/>
<property name="telefoneCentral" column="TELEFONECENTRAL" not-null="true"/>
<set name="pessoasDestinadas"
cascade="all"
lazy="true"
inverse="true"

>
<key column ="DESTINO_ID"/>
<one-to-many class="hello.PessoaDestinada"/>
</set>
<set name="ramais" lazy="true" inverse="true" cascade="all" >
<key column="DESTINO_ID"/>
<one-to-many class="hello.Ramal"/>
</set>
<set name="ligacoes" lazy="true" inverse="true" cascade="all">
<key column="DESTINO_ID"/>
<one-to-many class="hello.Ligacao"/>
</set>
</class>
</hibernate-mapping>



Child
XML


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="hello.Ligacao" table="LIGACOES" lazy="true">
<id name="id" column="LIGACAO_ID" unsaved-value="any">
<generator class="increment" />
</id>
<property name="dataHora" column="DATAHORA" not-null="true"/>
<property name="motivo" column="MOTIVO" />
<property name="numero" column="NUMERO" not-null="true" />
<property name="duracao" column="DURACAO" not-null="true"/>

<many-to-one name="destino" column="DESTINO_ID" not-null="true"
class="hello.Destino"
update="false"
cascade="save-update"/>

<many-to-one name="pessoa" column="PESSOA_ID" not-null="true"
class="hello.Pessoa" cascade="save-update"/>

<many-to-one name="funcionario" column="FUNCIONARIO_ID" not-null="true"
class="hello.Funcionario" cascade="save-update"/>
</class>
</hibernate-mapping>



Code between session open/close

Ligacao ligacao= new Ligacao();

* Detached -> destino,funcionario,pessoa

destino.addLigacao(ligacao);
funcionario.addLigacao(ligacao);
pessoa.addLigacao(ligacao);

SQL

Hibernate: insert into LIGACOES (DATAHORA, MOTIVO, NUMERO, DURACAO, DESTINO_ID, PESSOA_ID, FUNCIONARIO_ID, LIGACAO_ID) values (?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update DESTINOS set NOME=?, ENDERECO=?, PAIS=?, TELEFONECENTRAL=? where DESTINO_ID=?
Hibernate: update PESSOAS set NOME=?, TELEFONE=?, CELULAR=? where PESSOA_ID=?
Hibernate: update FUNCIONARIOS set MATRICULA=?, CARGO=?, NOME=?, TELEFONE=?, EMAIL=? where FUNCIONARIO_ID=?



I found in the forum that i cannot avoid these update, or other querie, just doing the insert. Is it right ?!

Thank you.

do you know what does "detached" means?
it means that the session is no more able to detect any change.
So how do you think a re attachment is executed?
2 possibilities:
- make a select to be able to check both versions
- update all the graph

is it clear?

you should read hibernate in action

Very clear , thank you very much.