juddi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Luisser (Jira)" <juddi-...@ws.apache.org>
Subject [jira] [Created] (JUDDI-1012) MS SQL Server Sequence table change
Date Fri, 26 Jun 2020 14:42:00 GMT
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)

Mime
View raw message