Primary Key uuid.string or uuid.hex on DB2

vijpan · **Joined:** Sat Nov 22, 2003 3:54 pm **Posts:** 42

Dear All,

I wanted to know which can be the better strategy for primary key generation on the DB2 database if we have choice between uuid.string or uuid.hex.

What does the hibernate team suggests for this . For a new application that is going to be build, should we make use of sequence/identity functionality that is being provided by the DB's or should go for algorithms like UUID.

Thanks

emmanuel · **Posted:** Tue Dec 16, 2003 5:00 am

vijpan wrote:

For a new application that is going to be build, should we make use of sequence/identity functionality that is being provided by the DB's or should go for algorithms like UUID.

It depends the abstraction you want from the DB. identity may be problematic since it needs to insert an empty line before having the id. Sequence Hilo is probably one of the best, since it minimize the DB roundtrip wo the need of a new table and it can still be inserted in a transaction (not hilo unfortunatly).