@GeneratedValue(strategy=GenerationType.AUTO) with SQL Server behavior has changed in EAP 6

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.