Robert, it was cache indeed. By default sequences assume a cache of 20. I had to recreate the sequence like:
create sequence seq_xxx start with nnn NOCACHE Otherwise it will jump after the restart. Thank you for pointing me to the right direction. Best regards, Martin On 7/4/06, Martin Cordova <[EMAIL PROTECTED]> wrote:
I checked sequence definitions via SQLStudio, "Cached values" is disabled, without information. SEQUENCE_CACHE = 1 according to DBM. Is there anything else to check? I created the sequence like: create sequence seq_xxx start with 1 Did it assume a default cache of 20 or something? Regards, Martin On 7/4/06, Robert Klemme <[EMAIL PROTECTED]> wrote: > 2006/7/4, Martin Cordova <[EMAIL PROTECTED]>: > > Hello: > > > > I have a sequence that jumps 19 values when used the first time after > > a database restart. > > > > Normally it works fine, until a Db restart, then jumps 19 values. > > This might be due to caching of sequence values. > > Kind regards > > robert > -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com
-- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
