I'm using update to understand the problem, because really I need a SaveOrUpdate, but NH generate always an INSERT, so I'm trying with Update method that should never generate an INSERT but always an UPDATE... instead I'm getting this throuble.
Any idea ?
Hibernate version: 1.2.0 CR1
Mapping documents:
Code:
<hibernate-mapping xmlns='urn:nhibernate-mapping-2.2'>
<class name='CUP.Domain.ReservationHeader, CUP.Domain' table='TESTATAPRENOTAZIONI' lazy='false'>
<composite-id>
<key-property name='Year' column='PREANN' />
<key-property name='Number' column='PRENUM' />
</composite-id>
<version name='Version' column='PRETVE' unsaved-value='0' />
<property name='Patient' column='PREPAZ' />
<many-to-one class ='CUP.Domain.Patient, CUP.Domain' insert='false' update='false' name='PatientInfo' not-found='ignore'>
<column name='PREPAZ'/>
</many-to-one>
<property name='Type' column='PRETIP' />
<property name='Document' column='PRENUR' type='AnsiString(16)' />
<property name='DocumentDate' column='PREDAR' />
<property name='ReservationDate' column='PREDAP' />
<property name='InsertUser' column='PREUIN' />
<property name='InsertDateTime' column='PREDIN' />
<property name='UpdateUser' column='PREUMO' />
<property name='UpdateDateTime' column='PREDMO' />
<property name='CancelUser' column='PREUEL' />
<property name='CancelDateTime' column='PREDEL' />
<property name='AccessUser' column='PREUVI' />
<property name='AccessDateTime' column='PREDVI' />
<property name='PrintUser' column='PREUST' />
<property name='PrintDateTime' column='PREDST' />
<property name='RifYear' column='PREANA' />
<property name='RifNumber' column='PRENUA' />
<property name='CancelCode' column='PRENUL' />
<property name='Notes' column='PRENOT' />
<property name='Source' column='PREPRV' />
<property name='Regime' column='PREREG' />
<property name='SenderDoctor' column='PREMED' />
<property name='Disease' column='PREESZ' />
<property name='Priority' column='PREPRI' />
<property name='IUPCode' column='PREIUP' />
<property name='SuggestedExam' column='PRESUG' />
<property name='Other' column='PREALT' />
<property name='DocumentType' column='PRETIR' />
<property name='Urgent' column='PREURG' type='AnsiString(1)' />
<many-to-one class='CUP.Domain.Ente, CUP.Domain' name='Ente' not-found='ignore' insert='false' update='false'>
<column name='PREENCOD'/>
<column name='PREENDTDA'/>
</many-to-one>
<bag name ='Details' cascade='all' table='RIGHEPRENOTAZIONI' lazy='false'>
<key>
<column name='PREANN'/>
<column name='PRENUM'/>
</key>
<one-to-many class='CUP.Domain.ReservationDetail, CUP.Domain' />
</bag>
</class>
</hibernate-mapping>
Code:
<hibernate-mapping xmlns='urn:nhibernate-mapping-2.2'>
<class name='CUP.Domain.ReservationDetail, CUP.Domain' table='RIGHEPRENOTAZIONI'>
<composite-id>
<key-property name='Year' column='PREANN' />
<key-property name='Number' column='PRENUM' />
<key-property name='DetailRow' column='PRERIG' />
</composite-id>
<version name='Version' column='PRERVE' unsaved-value='0' />
<property name='Document' column='PRERIC' />
<property name='ReservationDate' column='PREDAT' />
<property name='Hour' column='PREORA' />
<property name='Minute' column='PREMIN' />
<property name='MainCategoryID' column='PRESPKEY' />
<property name='DiagnosticID' column='PREDIACOD' />
<property name='PerformanceTypeID' column='PRETPRCOD' />
<property name='ExamID' column='PREARKEY' />
<property name='InsertUser' column='PREUID' />
<property name='InsertDateTime' column='PREDID' />
<property name='UpdateUser' column='PREUMD' />
<property name='UpdateDateTime' column='PREDMD' />
<property name='CancelUser' column='PREUED' />
<property name='CancelDateTime' column='PREDED' />
<property name='AccessUser' column='PREUVD' />
<property name='AccessDateTime' column='PREDVD' />
<property name='PrintUser' column='PREUSD' />
<property name='PrintDateTime' column='PREDSD' />
<property name='CancelCode' column='PRERNU' />
<property name='RowType' column='PRETYP' />
<many-to-one class ='CUP.Domain.Exam, CUP.Domain' name ='Exam' insert='false' update='false' not-found='ignore'>
<column name='PRESPKEY'/>
<column name='PREDIACOD'/>
<column name='PRETPRCOD'/>
<column name='PREARKEY'/>
</many-to-one>
<many-to-one class='CUP.Domain.ExamDescription, CUP.Domain' name='ExamInfo' column='PREARKEY' insert ='false' update='false' not-found='ignore'/>
<many-to-one class ='CUP.Domain.ReservationHeader, CUP.Domain' insert='false' update='false' name ='ParentHeader' not-found='ignore'>
<column name ='PREANN'/>
<column name ='PRENUM'/>
</many-to-one>
<many-to-one class='CUP.Domain.Diagnostic, CUP.Domain' name='Diagnostic' insert='false' update='false' not-found='ignore'>
<column name='PRESPKEY'/>
<column name='PREDIACOD'/>
</many-to-one>
<many-to-one class='CUP.Domain.Availability, CUP.Domain' name='Availability' insert ='false' update='false' not-found='ignore'>
<column name='PRESPKEY'/>
<column name='PREDIACOD'/>
<column name='PRETPRCOD'/>
<column name='PREDAT'/>
<column name='PREORA'/>
<column name='PREMIN'/>
</many-to-one>
</class>
</hibernate-mapping>
load entity
Code:
this.m_session.Clear();
ReservationHeader parmRes = new ReservationHeader();
parmRes.Year = int.Parse(dgvReservations.SelectedRows[0].Cells["dgvcolYear"].Value.ToString());
parmRes.Number = int.Parse(dgvReservations.SelectedRows[0].Cells["dgvcolNumber"].Value.ToString());
this.Reservation = this.m_session.Get<ReservationHeader>(parmRes);
this.Reservation.Mode = "*";
foreach (ReservationDetail detail in this.Reservation.Details)
{
detail.Mode = "*";
}
update entity
Code:
this.m_session.Update(this.Reservation);
this.m_session.Flush();
this.m_session.Clear();
Full stack trace of any exception that occurs:
in NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)
in NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)
in NHibernate.Impl.ScheduledInsertion.Execute()
in NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
in NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
in NHibernate.Impl.SessionImpl.Execute()
in NHibernate.Impl.SessionImpl.Flush()
in CUP.frmReservation.kbConfirm_Click(Object sender, EventArgs e) in
--- EXCEPTION ---
{"could not insert: [CUP.Domain.ReservationDetail#CUP.Domain.ReservationDetail][SQL: INSERT INTO RIGHEPRENOTAZIONI (PRERVE, PRERIC, PREDAT, PREORA, PREMIN, PRESPKEY, PREDIACOD, PRETPRCOD, PREARKEY, PREUID, PREDID, PREUMD, PREDMD, PREUED, PREDED, PREUVD, PREDVD, PREUSD, PREDSD, PRERNU, PRETYP, PREANN, PRENUM, PRERIG) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]"}
Name and version of the database you are using:
Oracle 10g
The generated SQL (show_sql=true):
{INSERT INTO RIGHEPRENOTAZIONI (PRERVE, PRERIC, PREDAT, PREORA, PREMIN, PRESPKEY, PREDIACOD, PRETPRCOD, PREARKEY, PREUID, PREDID, PREUMD, PREDMD, PREUED, PREDED, PREUVD, PREDVD, PREUSD, PREDSD, PRERNU, PRETYP, PREANN, PRENUM, PRERIG) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}
Login
FAQ
Search
