Hi

I am developing an application that needs to be replicated down to a mobile device. To do this I need a column in each table that is updated with a sequence number.

Try as I might I cannot find hwo to do thsi in the docs, the Book, or the forum.

So the question is.

How do I map a property so that when ever the object is saved the property is updated from a sequence?

Any help greatly appreciated.

Regards

Richard Spence

Use the <version> element. If you turn on generated="true" it effectively becomes a sequence/identity value.

Thanks for your reply but things are still not clear.

The version element has the following syntax

<version
column="version_column" (1)
name="propertyName" (2)
type="typename" (3)
access="field|property|ClassName" (4)
unsaved-value="null|negative|undefined" (5)
node="element-name|@attribute-name|element/@attribute|."
/>

I can't see how to add a generated=true.

Could you point me to an example?

Thanks again

Richard Spence

The generated element is new to 3.1. You didn't specify which versoin you're using, so I guessed. Wrong, obviously :). For earlier versions, you can create your identity or sequence column in your DB, and specify it in your mapping using <property name="whatever" formula="columnname"/>. It's nearly as good.

BTW, I made a booboo, it's 'generated="always"', not ="true".