[ https://issues.apache.org/jira/browse/JUDDI-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex O'Ree resolved JUDDI-1012. ------------------------------- Fix Version/s: 3.3.8 Assignee: Alex O'Ree Resolution: Fixed > 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 > Assignee: Alex O'Ree > Priority: Major > Fix For: 3.3.8 > > > 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)