Hi,

I use an entity bean looking like this

@Entity
@Table(name="t_gridcells", schema="grid")
@SequenceGenerator(name="GridCellBeanSequence", sequenceName="grid.s_gridcells")
public class GridCellBean {

 private Integer id;

 @Id(generate=GeneratorType.SEQUENCE, generator="GridCellBeanSequence")
 public Integer getId() {
 return id;
 }

 public void setId(Integer id) {
 this.id = id;
 }

}

This works. The sequence s_gridcells in my grid schema is used to generate the id for new beans.
The only problem is that when I deploy my ear-file the JBoss server gives the following error-output:

-------------------------------------------------------
09:31:23,093 INFO [DatabaseMetadata] table not found: grid.s_gridcells

09:31:23,203 ERROR [SchemaUpdate] Unsuccessful: create sequence grid.s_gridcells
09:31:23,203 ERROR [SchemaUpdate] ERROR: relation "s_gridcells" already exists
-------------------------------------------------------

Does anyone have a clue how to fix this?

I know that if I change the sequenceName="grid.s_gridcells" to sequenceName="s_gridcells" the sequence isn't used/found. So, because there is no "schema" attribute in the SequenceGenerator-annotation I put the "grid." in front of the name.

Any help is extremely welcome....

cheers,
pj