The problem is each table has its own audit fields. But there are also other stored procedure more complex we need to use to update tables. What could the problem be in this case? Why does the error came up in this case?
On 17 jun, 11:33, Eddie <[email protected]> wrote: > For the moment we cannot use a triger due to a company policy > > On 17 jun, 11:14, Gianluca Gravina <[email protected]> wrote: > > > > > Or an EventListner ? > > > U can google for different examples here's one from nhforge: > > >http://nhforge.org/wikis/howtonh/creating-an-audit-log-using-nhiberna... > > > <http://nhforge.org/wikis/howtonh/creating-an-audit-log-using-nhiberna...> > > Cheers, > > > Gianluca > > > On Thu, Jun 17, 2010 at 4:06 PM, Diego Mijelshon > > <[email protected]>wrote: > > > > If it's only to update a field, why not use a trigger instead? > > > > Diego > > > > On Thu, Jun 17, 2010 at 11:04, Eddie <[email protected]> wrote: > > > >> 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]<nhusers%[email protected] > > >> > > > >> . > > >> For more options, visit this group at > > >>http://groups.google.com/group/nhusers?hl=en. > > > > -- > > > 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]<nhusers%[email protected] > > > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en. > > > -- > > Gianluca Gravinahttp://blogs.ugidotnet.org/thinkingingrava -- 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.
