HI Dhamu, ----- Original Message ----- From: "Dhamodharan P" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]>; "Armin Waibel" <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 4:04 AM Subject: Re: Sequence Mgr/Primary Key problem
> > Hi Armin, > > I am using OJB with Oracle in tomcat server, autoincrement of my primary key is working fine.But when i shutdown and restart the server, the primary key value randomly increasing. > > For example before shutdown my primary key value is 10 means, after restart it will be 21 or 20(its varing randomly).Canyou help me. Do you mean primary key in the sequence table, or the primary key of the next object after restart? Keep in mind that the HI/LO sequence manager buffers per default 10 keys per sequence name. So you will lost unconsumed keys when shutdown. When using the SequenceManagerHiLoImpl you could try using SequenceManagerHiLoContinuousImpl, this implementation reduce the lost keys after shutdown (max lost keys is grabSize). regards, Armin > > Thanks in advance > > Dhamu > > > > > > > --------------------------------- > Get a bigger mailbox -- choose a size that fits your needs. > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
