Hi
I want to update an object using a stored procedure. The reason to do
this is to update a field 'last_update_date'. So in the sp I set
last_update_date = getdate() because a need to save the server time.
The problem is I am getting an error when using stored procedure.
Error: "Batch update returned unexpected row count from update; actual
row count: 0; expected: 1"
If I remove <sql-update > the record is updated but no the field
last_update_date.
How I can solve this error?
There is another way to update this kind of fields?
This is my mapping file:
hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="HP.NHibernate.Framework"
namespace="HP.NHibernate.Framework.Domain">
<class name="Objeto" catalog="Trabajos" schema="dbo"
table="NHObjetos" >
<id name="Codigo" type="String" unsaved-value="">
<column name="codigo" sql-type="varchar" length="5" not-
null="true" unique="true"/>
<generator class="assigned" />
</id>
<property name="Descripcion" type="String">
<column name="descripcion" length="50" sql-type="varchar" not-
null="true" />
</property>
<property name="UpdateDate" type="DateTime" update="false"
insert="false" generated="always" >
<column name="last_update_date" sql-type="datetime" not-
null="true" />
</property>
<sql-update >exec Trabajos.dbo.NHObjetos_Update ?,? </sql-update>
</class>
</hibernate-mapping>
My code is:
public void UpdateObjeto()
{
using (RepositoryBase repo = new RepositoryBase())
{
try
{
repo.BeginTransaction();
Objeto objeto = (Objeto)
repo.GetById(typeof(Objeto), "DEF45");
objeto.Descripcion = "pepepe";
repo.Update(objeto);
repo.CommitTransaction();
}
catch (Exception ex)
{
repo.RollbackTransaction();
}
}
}
I will apreciate any tip.
Thanks.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
