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.