[b]Hibernate version:[/b]

nhibernate 1.2.0

[b]Mapping documents:[/b]

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="Frequentis.PCDDMS.BusinessLayer.RegisterData, Frequentis.PCDDMS.BusinessLayer" table="[RegisterData]">
<id name="Sender" column="Sender" type="String">
<generator class="assigned" />
</id>
<property column="Timestamp" name="Timestamp" type="DateTime"/>
</class>
</hibernate-mapping>

[b]Code between sessionFactory.openSession() and session.close():[/b]

RegisterData regData = new RegisterData();

regData.Sender = request.RequestSender.ToString();
regData.Timestamp = DateTime.Now;
_session.BeginTransaction(System.Data.IsolationLevel.RepeatableRead);
{
_session.Save(regData);
//_session.SaveOrUpdate(regData);
}

_session.Transaction.Commit();
_session.Flush();

[b]Name and version of the database you are using:[/b]

ms sql 2005

I have a table that contains a column for enpoints. nvarchar(50) , primary key , and a datetime column , for timestamps. i need to store the last timestamp an enpoint has send a request. when i first save an enpoint it works fine. but if the endpoint is allready in db , then , if i call update , an exception is thrown.

can u please tell me how to fix this , or an alternative.
thank you.

Should be... and column timestamp must be of type timestamp, not datetime.

However...


If you want a modified date look into creating an intercepter to auto update the date on each save or update in nhibernate.

the problem is not the timestamp property. i just named it like this , but actually it is a datetime column , and the property also. the difficulties arise with the primary key.i changed the primary key to type int , and generated , and everything works fine. but i need the primary key on a string column.

thanks

Actually what exception did you see? Post exception with full stack trace please.