Primary key generation in jpa : sequence type.

[rdheepan]

Hi All,
I am Dheepan. Whenever i am generating primary key using @GeneratedValue and @Sequencegenerator,
It is creating just random numbers instead of creating the sequence number as specified.. and some of
my friends says that it will be generated in mySql but not in sql plus... Can somebody tell me why it is not
creating the sequence numbers in sqlPlus? -Thanks in advance

[doWhile]

Cross posted at Jpa Primary key generation

[rdheepan]

Since I am new to this forum i dont know the rules.. what should i do now?

[dinesh.guntha]

@GeneratedValue(strategy=GenerationType.SEQUENCE)
it will generate the sequence values.

[rdheepan]

Thanks for your reply dinesh,
I have used that syntax only.
@GeneratedValue(strategy=GenerationType.SEQUENCE,g enerator="dheepan")
@SequenceGenerator(initialValue=1,allocationSize=1 , name = "dheepan", sequenceName="dheepan")

This is what i did. It should start from 1 and go on 2,3,4... like that in a sequence order .. but the numbers that are created was,
401,0,52,273 like this it is creating some random numbers... It is on sql plus server..I heard that for MySql it is creating the exact values.. But i dont know why it is not working in sql plus? I am using sql plus..