Uploaded image for project: 'jUDDI (Retired)'
  1. jUDDI (Retired)
  2. JUDDI-1012

MS SQL Server Sequence table change

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.3.7
    • 3.3.9
    • core
    • None

    Description

      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;

      Attachments

        Activity

          People

            spyhunter99 Alex O'Ree
            sluisser Steve Luisser
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: