2 Replies Latest reply on Mar 13, 2006 5:57 PM by Daniel Cardin

    Create table with ID as Auto increment

    janinmobia Newbie

      Hi All,

      I'm trying to create an entity bean with an ID that auto increments on MySQL.

      My ID lookes like this

      @Id(generate = GeneratorType.AUTO)
      public int getId() {
      return id;
      }
      public void setId(int id) {
      this.id = id;
      }



      And everything goes fine until I deploy it and it tries to create the table

      create table binary_data (id integer generated by default as identity (start with 1), data varbinary(255)......

      MySQL is not to happy about generated by default as identity (start with 1)
      ....


      Any one that can see what I'm doing wrong?

      Cheers
      Jan