Hi Armin,
Thanks a lot, its working fine.But i need to create a following table in
my database
CREATE TABLE OJB_SEQ(
TABLENAME VARCHAR(175) NOT NULL,
FIELDNAME VARCHAR(70) NOT NULL,
LAST_NUM NUMBER,
CONSTRAINT SYS_PK_OJB_SEQ PRIMARY KEY(TABLENAME,FIELDNAME)
);
Regards
Dhamu
Armin Waibel <[EMAIL PROTECTED]> wrote:HI Dhamu,
----- Original Message -----
From: "Dhamodharan P"
To: "OJB Users List" ; "Armin Waibel"
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:
For additional commands, e-mail:
---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.
