Steve Luisser created JUDDI-1012:
------------------------------------
Summary: 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
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)
