merging/update based on alternative key?

seanlaval · **Joined:** Thu Apr 28, 2005 7:22 am **Posts:** 3

I have a mapping as follows...

Code:

   <class entity-name="Author" table="Author" node="content">
      <id name="id" type="integer">
         <column name="AUTHOR_ID" not-null="true" />
         <generator class="identity" />
      </id>
      <property name="email" column="email" node="author" type="string" unique="true" />
   </class>

so my Author class has a db generated surrogate key for joins etc but I want to be able to update data in the db based on an alternative key, email address? Is this possible? How would I go about it if so. Thankyou in advance.

emmanuel · **Posted:** Mon May 02, 2005 7:05 am

You'll have to do a query to get the object. Note that the query can be cached.