HI
i have a table structure like this

Retailer :

Guid
activeflag
Retailer_uid
name
lastname
..
..


here on a same transaction i need to populate Guid and Retailer_uid column with the same value .i know we are having identifier generator for guid like assigned , sequence . how can i populate retailer_uid here . this should be same as guid . i cannot use triggers because it will introduce row level locking .
what is the best alternate for this .
help appreciated

I think I'd do the mapping in the normal way, but in my java class, I would implement setRetailer_uid(Guid x) to do nothing, and getRetailer_uid() to return getGuid(). That will do it quickly and easily.