0 Replies Latest reply on Feb 28, 2008 4:31 AM by wilfried deguil

    EJB3 and GenerationType.AUTO on Sqlserver 2005

    wilfried deguil Newbie

      Hello,

      I'm using Jboos 4.2.0.0 GA and Sqlserver2005 and Mysql.

      I have an EJB3 entity with this annotations :

      @Entity
      public class Test implements Serializable {
      private int id;
      @Id
      @GeneratedValue(strategy=GenerationType.AUTO)
      public int getId();
      {
      return id;
      }
      }

      When i start my server Jboss on the mySql server database the Test table is creating with success.

      So, when i start my server jboss on the sqlserver 2005 database, i have this error :

      Syntaxe incorrect vers 'auto_increment'.
      Unsuccessfull : create table test (id integer not null auto_increment);

      Any ideas.

      Thanks.