0 Replies Latest reply on Feb 10, 2013 2:52 PM by fabio valsecchi

    How to get the id of entity with auto_increment value?

    fabio valsecchi Newbie

      Hi there,

       

      I've an entity Order with @GeneratedValue(strategy = GenerationType.IDENTITY) annotation (I've a MySql database).

       

      ----------------------------------------------------------------------------------------------------------------

      @Entity

      @Table(name = "orders")

      public class Order implements Serializable {

      private static final long serialVersionUID = 3L;

       

          public Order() {

              super();

          }

       

      @Id

          @GeneratedValue(strategy = GenerationType.IDENTITY)

          @Column(name = "id")

          private int id;

       

      .....

       

      ----------------------------------------------------------------------------------------------------------------

       

      The persist of the order works well. The problem is that after the persist is done, if I try to execute the getId() method of the Order entity the value returned is always zero.

      The id field of the table orders is an auto_increment value and looking in the database after the persist its value is correctly inserted.

       

      How can I fix the problem? Looking in the internet there are a lot of suggestions saying to use GenerationType.TABLE or GenerationType.SEQUENCE that are not compatible with MySql.

       

      Thank you in advance