wrong value generated by a sequence generator in jboss-4.0.5

[maheshp]

Hello All,

we are using Jboss-4.0.5GA version with oracle 10g database, When we use the sequence generator it is giving some big value(if we fetch the same through db it will give very small number).

Same sequence was working fine with jboss-4.0.3sp1 and oracle 9i.

i have given sample code below,
//sequence generator defination
@javax.persistence.SequenceGenerator(name="SEQ_PRJ",
sequenceName="S_PHX_PROJEKTE")

//used with the attribute
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator="SEQ_PRJ")

please let me know, what could be the problem?

Thanks in Advance

[andydale]

Hi,

In the @SequenceGenerator annotation add the following attributes:

allocationSize=1, initialValue=1

You can leave the initialValue attribute out if you want, as all you should need to get it to work correctly is the allocationSize attribute.

Cheers,

Andy

[maheshp]

Thanks Andy

Its working after setting allocationSize attribute.