Re: SequenceGenerator not using cached ids.

[Craig L Russell]

Seems like what you want is the sequence definition in PG to have an increment of say 100, and then the SELECT NEXTVAL will return 1, 101, 201, etc. So the OpenJPA implementation should know that the NEXTVAL is going to be incremented by 100 and should internally dispense the 100 ids that the NEXTVAL gave it.

Craig

On Sep 21, 2007, at 2:27 AM, ben short wrote:

Patrick,

Here are the document pages

[1] http://www.postgresql.org/docs/8.2/interactive/sql- createsequence.html [2] http://www.postgresql.org/docs/8.2/interactive/functions- sequence.html

And my DDL

CREATE SEQUENCE categoryidseq
  INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 100
  CACHE 50;
ALTER TABLE categoryidseq OWNER TO jpa;

I can then use it via pgAdmin with the following sql..

SELECT nextval('categoryidseq');

And it returns id's incemented by 1.

Regards

Ben

On 9/21/07, Patrick Linskey <[EMAIL PROTECTED]> wrote:

Yep, I think that this is a bug of some sort. We're using the sequence:

28516313> executing prepstmnt 1772552 SELECT NEXTVAL('CategoryIdSeq')

but we're just selecting the next value, not the increment size. It's
weird that we are then using the increment size in the returned
values, though.



-Patrick

On 9/20/07, ben short <[EMAIL PROTECTED]> wrote:

Does anyone know the syntax in Postgres to select a batch of numbers from a seq?

My work around was to set the allocationSize property to 1, but that
kind of defeats the point of caching the id's.

Regards

Ben

On 9/20/07, Takeichi Kanzaki Cabrera <[EMAIL PROTECTED]> wrote:

I have the same problem using postgresql + openjpa-1.0 and at this
time I have no solution for it.

--
Regards,
Takeichi Kanzaki Cabrera
Linux Registered User #308138

If you want to be original,
be your self.

--
Patrick Linskey
202 669 5907

Craig Russell
Architect, Sun Java Enterprise System http://java.sun.com/products/jdo
408 276-5638 mailto:[EMAIL PROTECTED]
P.S. A good JDO? O, Gasp!

smime.p7s
Description: S/MIME cryptographic signature