4.0.4.CR2 => 4.0.4.GA @SequenceGenerator now ignored...

[supernovasoftware.com]

I am using sequences to generate all of my pks using PostgreSQL 8.1.3. This was working fine until I upgraded to 4.0.4.GA from 4.0.4.CR2.

Now none of my sequences are not working on some 70+ entities.

They are being assiged from some other source. Probably the default stragety.

After restarting the application. It seems a new pool of pks is grabbed in a block of 50, but my sequences are not affected.

My application is quite dependent on these sequences working as I had them set up.

See annotation code below.

@Entity
@Table(name="t_size")
public class Size implements Serializable {

 private Long id;
 @Id @GeneratedValue( strategy=GenerationType.SEQUENCE, generator="seq_size")
 @SequenceGenerator(name="seq_size", sequenceName="seq_size" )
 public Long getId() { return this.id; }
 public void setId(Long id) { this.id = id; }
....
}

This is a total show stopper and I must resolve ASAP.

Any assistance would be greatly appreciated...........

[supernovasoftware.com]

I just found the JIRA issue for this which has a workaround.

http://jira.jboss.com/jira/browse/EJBTHREE-597

Could someone please comment on the status of this issue?

[supernovasoftware.com]

The following workaround from JIRA worked.

@Entity
@Table(name="t_size")
@GenericGenerator(name="seq_size", strategy = "sequence",
 parameters = { @Parameter(name="sequence", value="seq_size") } )
public class Size implements Serializable {

 private Long id;
 @Id @GeneratedValue( strategy=GenerationType.SEQUENCE, generator="seq_size")
 public Long getId() { return this.id; }
 public void setId(Long id) { this.id = id; }

...
}

Thanks David.

[dbudworth]

Had the same problem here, and the workaround was the only way to get the sequences to be used.

This was on 4.0.4 GA (using EJB3 exactly as shipped with 4.0.4 GA), and oracle 10g (but it seems to not be database specific)

[epbernard]

@SequenceGenerator(allocationSize=1) is the way to do it property

[supernovasoftware.com]

Thank you Emmanuel. The following does in fact work for me.

private Long id;
 @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq_coupling_spec")
 @Id
 @SequenceGenerator(name = "seq_coupling_spec", sequenceName = "seq_coupling_spec", allocationSize=1)
 public Long getId() { return this.id; }
 public void setId(Long id) { this.id = id; }

Could you please tell me why 1 is not the default or allocationSize a required parameter?

If this is not specified it seems to ignore the entire tag.

[epbernard]

Hum, I'm actually realizing right now that we made a mistake on the default allocationSize.
It is 50 right now ; while more efficient, this is not the "default" people expect

[supernovasoftware.com]

Actually some other strategy is used if this is left out.

For example one my sequence was at 18, but without the allocation size specified is was getting numbers close to 3000 and not incrementing my sequence at all.