0 Replies Latest reply on Apr 25, 2006 11:20 AM by Pieter-Jan Savat

    Schema update creates sequence in wrong schema

    Pieter-Jan Savat Newbie

      Hi all,

      Has anyone ever experienced this?

      I used to hardcode the schema name in my entity beans, but now I use a static import of the schema name
      (thinking that this would make it easy to switch between a live version and a debug version of the database-model)

      But when I set DB_SCHEMA_REQFORM from its original value "reqform" to
      "reqform_debug" and redeploy the project, the sequences are still created in "reqform". Why is that, I wonder?

      import static be.barc.reqform.server.system.DB.DB_SCHEMA_REQFORM;
      
      @Entity(access = AccessType.FIELD)
      @Table(name = "c_layout_fonts",
       schema = DB_SCHEMA_REQFORM
      )
      @SequenceGenerator(name = "LayoutFontBeanSequence", sequenceName = "s_layout_fonts")
      public class LayoutFontBean implements Serializable {
      
       @Id(generate = GeneratorType.SEQUENCE, generator = "LayoutFontBeanSequence")
       private long id;
      
      ...
      
      }


      cheers