Is there a way to generate non-sequence unique IDs in hibernate? The ids getting inserted into database cannot be generatred in sequence.

Thanks.

Use a UUID generator:



But why are you wanting to do this? If you want to make IDs visible to the user (through a web page) but don't want the user to know sequence numbers, you'll need to use some form of "encryption". It could be something very basic, but that's the right way. If this is what you are trying to do, use a native or increment generator and then encrypt / scramble it in some reasonable way.

Thanks SleepyBear, that makes sense but unfortunately that is not good enough for them.

The ids have be integer. Is there another way?

You can write your own generator. How about one that just returns the hashCode() of your business key? E.g. if all the objects in your table have a unique serial number, just return the hashCode of the serial number of the object from the generator. It will be sensible, useful, (probably) unique, and non-sequential.

Yes, you could use a plain old integer as a sequence number and then transform it into your non-sequential number. If you could explain how you're going to use this I could explain it in a way that makes more sense.

Basically, you could do something like multiply the sequantial integer with a large prime number to get a result that is "scrambled". You can also use modular exponentiation to essentially encrypt the integer.