Pessoa to com o seguinte problema, quando vou deletar um objeto que já existe relacionamento em outras tabelas ocorre o seguinte erro!
Hibernate: /* delete one-to-many modelo.Anamnese.anamneseRecordatorio */ update anamnese_recordatorio set anamnese_id=null where anamnese_id=?
(util.JDBCExceptionReporter 77 ) SQL Error: 0, SQLState: 22001
(util.JDBCExceptionReporter 78 ) Data truncation: Column was set to data type implicit default; NULL supplied for NOT NULL column 'anamnese_id' at row 1
abaixo segue meus arquivos .hbm
[code]<hibernate-mapping
>
<class
name="modelo.AnamneseRecordatorio"
table="anamnese_recordatorio"
>
<id
name="id"
column="id"
type="java.lang.Integer"
>
<generator class="increment">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-AnamneseRecordatorio.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>
<property
name="refeicao"
type="java.lang.String"
update="true"
insert="true"
column="refeicao"
/>
<property
name="alimento"
type="java.lang.String"
update="true"
insert="true"
column="alimento"
/>
<property
name="medida"
type="java.lang.String"
update="true"
insert="true"
column="medida"
/>
<property
name="quantidade"
type="java.lang.String"
update="true"
insert="true"
column="quantidade"
/>
<many-to-one
name="anamnese"
class="modelo.Anamnese"
cascade="delete"
outer-join="auto"
update="true"
insert="true"
column="anamnese_id"
not-null="true"
/>
</class>
</hibernate-mapping>[/code]
[code]<hibernate-mapping
>
<class
name="modelo.Anamnese"
table="anamneses"
>
<id
name="id"
column="id"
type="java.lang.Integer"
>
<generator class="increment">
<!--
To add non XDoclet generator parameters, create a file named
hibernate-generator-params-Anamnese.xml
containing the additional parameters and place it in your merge dir.
-->
</generator>
</id>
<property
name="pacienteID"
type="java.lang.Integer"
update="true"
insert="true"
>
<column
name="pacientes_id"
/>
</property>
<property
name="ADF"
type="java.lang.Integer"
update="true"
insert="true"
>
<column
name="ADF"
/>
</property>
<property
name="AQ"
type="java.lang.Integer"
update="true"
insert="true"
>
<column
name="AQ"
/>
</property>
<many-to-one
name="consulta"
class="modelo.Consulta"
cascade="none"
outer-join="auto"
update="true"
insert="true"
column="consultas_id"
not-null="true"
/>
<set
name="anamneseRecordatorio"
lazy="false"
cascade="delete-orphan"
sort="unsorted"
>
<key
column="anamnese_id"
>
</key>
<one-to-many
class="modelo.AnamneseRecordatorio"
/>
</set>
</class>
</hibernate-mapping>[/code]
Ele da o erro pq tenta dar um update na tabela sem o id? alguem consegue ver o motivo do problema?