This is by design in many sequence generators and is a _good_ thing. The block size is the number of IDs cached locally by the local representation of the sequence generator. High-low sequence generators work this way. IIRC the toplink sequence generator worked the same way.
The database issues a block of IDs to a local proxy to dole out to the persistence manager. If some go unused for some reason, they are thrown away. You don't want to try to return them to the database since an app may ask for several blocks of IDs and this would rapidly turn into a mess. -tim > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 4:03 PM > To: OJB Users List > Subject: RE: OJB vs Hibernate > > > > It doesn't really hurt anything, but why throw away numbers. > Why waste a key id number. I just makes the id number grow > faster. I just find it to be sloppy. I've never see a > database that skips like that. I don't restart the production > app very often so there's no big deal there. Do you not see > that as a waste to increment the numbers like that? > > > Thank You, > > Justin A. Stanczak > Web Manager > Shake Learning Resource Center > Vincennes University > (812)888-5813 > > > > > > "Lance Eason" > > > <[EMAIL PROTECTED] To: > "OJB Users List" <[EMAIL PROTECTED]> > > erwire.com> cc: > > > Subject: RE: > OJB vs Hibernate > > 03/31/03 03:38 PM > > > Please respond to > > > "OJB Users List" > > > > > > > > > > > > > Just as a philosophical question why do you care that it > jumps the count by 10 when you restart? The idea of a > meaningless primary key is simply to provide a unique > identifier for the row. What does it matter whether it's > continuous or not? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 2:33 PM > To: [EMAIL PROTECTED] > Subject: OJB vs Hibernate > > > I'm guessing someone has already asked this, but I'm going to > ask again. I'm currently using OJB. I like OJB just fine, > except the auto increment part. Every time I restart my web > app it jumps the count up ten. I know why it does that and > I'm guessing that if I set the increment count to one instead > of ten it would fix this. I'm not really sure I like all the > tables you have to create to run the ODMG part. I was > thinking of switching to Hibernate. I've looked at it some > and it looks like it does the same thing except the JDO. It > does say it supports ODMG. Any input would be great. Hey, > maybe I'm just not using OJB right. > > > Thank You, > > Justin A. Stanczak > Web Manager > Shake Learning Resource Center > Vincennes University > (812)888-5813 > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
