Unlimited Sequences

[jig]

Hi All,

Has anyone used anything other than 'Ebase sequence' to generate unique numbers?

After some trial & error, we found out that the highest number you can generate using a 'Ebase sequence' is 2147483647 (2 billion....).

2 billion+ is a lot of numbers but would love to hear if someone has come-up with a solutions/approach to generate unlimited sequence numbers (numeric/alpha numeric).

Regards
Jignesh

[Steve]

Hi Jig,

There are a few possibilities..

You could do similar to Ebase and write to a database. Note you will have to wrap it in a transaction and lock the sequence. Easiest way to do this is by synchronising a Java method to do it. There will be restrictions on the column length.

Another way is the write the next sequence to a file, then you will get no restrictions. Note that the same applies... you will need to lock the method to before reading and writing to the file.

Steve

[jig]

Thanks Steve!