HI

I need help in following scenario .

i have a table by name Retailer_Registry . it has following field mappings
guid,
Last_updated_user,
Addressline1
AddressLine2...
....
...
..
Retailer_Registry_UID etc .

Here apart from guid Retailer_Registry table column is unique . The value of this column in populated for each transaction from a different table called say UID pool . so i need to have a logic that will fetch the sequence.next val from UID pool table and populate it in to RETAILER_REGISTRY_UID Column .

i need to know how to get sequence.next val from dual in hibernate .

any help appreciated ..

I make a pardon

read as

Here apart from guid, RETAILER_REGISTRY_UID Column in unique .