[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155826#comment-17155826 ]
Alex O'Ree commented on JUDDI-1012: ----------------------------------- confirmed, the newer version of hibernate has a bunch of more dialects for different versions of sql server. I've added automated generation for the other versions and the output is exactly as you described. > MS SQL Server Sequence table change > ----------------------------------- > > Key: JUDDI-1012 > URL: https://issues.apache.org/jira/browse/JUDDI-1012 > Project: jUDDI > Issue Type: Improvement > Components: core > Affects Versions: 3.3.7 > Reporter: Steve Luisser > Priority: Major > > SQL Server 2012 is the oldest version that is supported by Microsoft. This > and newer versions support sequences. > > File mssql2000.ddl: > > create table hibernate_sequence (next_val numeric(19,0)); > Multiple instances of insert into hibernate_sequence values ( 1 ); > > Suggestion to change this to: > create sequence hibernate_sequence start with 1 increment by 1; > > To remove the sequence use: DROP sequence hibernate_sequence; -- This message was sent by Atlassian Jira (v8.3.4#803005)