create <timestamp> attribute in mapping file

angela · **Posted:** Wed Apr 19, 2006 4:13 am

Hello all

i'm trying to

Does anybody know how i can generate a timestamp attribute in my mapping file like that:

Code:

At the moment it's defined as follwoing in the reverse engineering file:

Code:

but this results in a normal property in the mapping file:

Code:

 <property name="mutDat" type="timestamp">
            <column name="DMUTDAT" length="11" not-null="true" />
        </property>

Any ideas?

regards
Angela

max · **Posted:** Wed Apr 19, 2006 8:22 am

not controllable in in reveng.xml (yet), but a custom strategy can do it:

Code:

public class YourRevEngStrategy extends DelegatingReverseEngineeringStrategy {

public YoirRevEngStrategy(ReverseEngineeringStratregy re) {
  super(re);
}

   public String getOptimisticLockColumnName(TableIdentifier identifier) {
                  if("theTable".equals(identifier.getName())) {
                       return "DMUTDAT";
                  } else {
         return super.getOptimisticLockColumnName(identifier);
                 }
   }
}

you can also choose to implement useColumnForOptimisticLock instead, but that is up to how you like to decide what the column is.

note that to have it be a timestamp the type of column should be something that is compatible with a timpestamp (date,timestamp,etc)

angela · **Posted:** Wed Apr 19, 2006 8:35 am

thanks, this works great! :-)

regards
angela