Re: [eclipselink-users] @SequenceGenerator initialValue oneclipselink.dd

[Frank Schwarz <fs5@xxxxxxx>]

Hi,

I tested your scenario and at least for the postges-dialect I can confirm
the observed behavior. EclipseLink ignores the initialValue-setting and only
honors the allocationSize-value. It simply takes the allocationSize-value
for the MINVALUE-setting.

-- Frank


Yohan Yudanara-2 wrote:
> 
> Hi,
> 
> Thanks 4 the response, but maybe my question is not clear.
> btw, the sequence is not already exist on the database.
> 
> I want eclipselink.ddl-generation to generate sequence for me starting
> with value *10000*.
> I'm using this annotation to do that:
> @SequenceGenerator(name="RoleSeq",sequenceName="seq_role",initialValue=10000)
> 
> But, the generated sequence is start with 50:
> CREATE SEQUENCE seq_role
> INCREMENT 50
> MINVALUE 1
> MAXVALUE 9223372036854775807
> START **50**
> CACHE 1;
> 
> instead of start with 10000 (I expect 10000 because I've use
> initialValue=10000 on my annotation)
> CREATE SEQUENCE seq_role
> INCREMENT 50
> MINVALUE 1
> MAXVALUE 9223372036854775807
> START **10000**
> CACHE 1;
> 
> Is this an eclipselink bug? or is this my fault to not understand what
> "initialValue" means ?
> Plz help..
> 
> Thanks..
> 
> 
> 
> On Fri, Apr 30, 2010 at 8:14 PM, Andrei Ilitchev
> <andrei.ilitchev@xxxxxxxxxx> wrote:
>> May be the sequence with start 50 already exists in the db?
>> Either drop the sequence from the db "by hand", or alternatively use
>> "drop-and-create-tables" instead of "create-tables"
>> ----- Original Message ----- From: "Yohan Yudanara"
>>
>>> Hi..
>>>
>>> I'm using JPA 2.0 on Glassfish v3.0.
>>> I'm running Postgresql 8.4 and postgresql-8.4-701.jdbc4 JDBC Driver on
>>> JDK 6 and Vista.
>>>
>>> I've found a problem that might be a bug.
>>> When I'm using initialValue on @SequenceGenerator annotation and use
>>> eclipselink.ddl-generation (create-tables) on persistence.xml, the
>>> generated sequence always ignore the initialValue attribute.
>>>
>>> This is my annotation:
>>>
>>> @SequenceGenerator(name="RoleSeq",sequenceName="seq_role",initialValue=10000)
>>> @Id @GeneratedValue(generator="RoleSeq")
>>> @Column(name="id")
>>> private Long id;
>>>
>>> And this is the generated sequence: (start value is always 50, not
>>> 10000)
>>> CREATE SEQUENCE seq_role
>>>  INCREMENT 50
>>>  MINVALUE 1
>>>  MAXVALUE 9223372036854775807
>>>  START 50
>>>  CACHE 1;
>>>
>>> Does anyone experience this problem?
>>> Should I report this as a bug?
>>>
>>> Thanks...
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> 
> 

-- 
View this message in context: http://old.nabble.com/%40SequenceGenerator-initialValue-on-eclipselink.ddl-generation-is-ignored-tp28408270p28429557.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.