Set your next_val high enough (instead of defaulting to zero) so that it doesn't collide. I think the standard max_lo value is 100 (it defaults to 32,768 I believe). If that is your case than you would need to set your next_val to 35 to prevent collision.
On Jul 6, 4:20 pm, Paulo Quicoli <[email protected]> wrote: > Hi friends... > > we decided to build a new version of our system using now NHibernate. In > this new system we are using hilo for id generation. > For while this system is not in production, but, i'm worried about > something. > > When get time, we will need change old system for this new one and migrate > old database... > > in our old database, all PKs are generated by Sequences, each table has it > sequence. > > Now we are using Hilo, one hilo for all entities... when importing data > maybe i will have an old record using ID 3456. > How can i make sure hilo will not generate a 3456 id also ? > > thanks for your helping! > > -- > Paulo R. Quicoli > > Editor Técnico - ClubeDelphi Magazine - DevMedia --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
