1 Reply Latest reply on Dec 30, 2005 8:18 PM by Emmanuel Bernard

    Order of Columns on Table Create

    Shiung Yong Newbie

      Hi,
      What is the default order in which columns in a database table are automatically created by an entity bean deployment in JBoss? It seems that the order of declaration in the entity bean .java file does not affect the actual ordering of columns. Is there a way to force columns to be in a certain order? I could not find any annotation for this.

      The following .java entity code:

       private String user_login_id;
       private int party_id;
       private String current_password;
       private int password_hint;
       private char enabled;
       private Timestamp disabled_date_time;
       private int successive_failed_logins;
       private String licenseid;
       private Timestamp last_updated_stamp;
       private Timestamp last_updated_tx_stamp;
       private Timestamp created_stamp;
       private Timestamp created_tx_stamp;
      


      produces the following table columns, in order:
      user_login_id
      enabled
      current_password
      successive_failed_logins
      party_id
      licenseid
      created_stamp
      created_tx_stamp
      disabled_date_time
      last_updated_stamp
      last_updated_tx_stamp
      password_hint

      Please help, thank you.