@GeneratedValue(strategy=GenerationType.AUTO) with SQL Server behavior has changed in EAP 6
Issue
In previous versions of JBoss all of our datatypes extend from a class which defines the ID. This is the Id methods
@Column(name="IID")
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
@Override
public long getId(){return id;}
public void setId(long id){this.id = id;}
This worked fine, allowing the database tables to generate their id's with the SQL Server identity datatype.
Now when we try and persist new datatypes we get the following:
14:00:46,554 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/Test].[Faces Servlet]] (http-/0.0.0.0:80-5) JBWEB000236: Servlet.service() for servlet Faces Servlet threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'hibernate_sequence'.
Environment
Red Hat JBoss Enterprise Application Platform (EAP) 6
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.