mssql create sequence

General Discussion
1

Hi,

I have this message for create sequence on mssql

  1. createSequence is not supported on mssql.
sequence is now supported on mssql 2012 (http://msdn.microsoft.com/fr-fr/library/ff878091.aspx)

but the class MSSQLDatabase return false for this db object
  1. @Override
        public boolean supportsSequences() {
            return false;
        }
is it possible to change this code with a version check ?

you can obtain the version of mssql with this query

  1. select @@version
the result is

  1. Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15  Copyright © Microsoft Corporation
        Business Intelligence Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)


thanks

julien.

2

the code can be modify like this

  1. @Override
        public boolean supportsSequences() {
            if (getConnection().getDatabaseMajorVersion()>= 11) {
                return true;
            }
            return false;
        }
value for mssql 2012
  1. System.out.println("database Product Name     : " + conn.getMetaData().getDatabaseProductName());
    System.out.println("database Product Version  : " + conn.getMetaData().getDatabaseProductVersion());
    System.out.println("database Major version    : " + conn.getMetaData().getDatabaseMajorVersion());
    System.out.println("database Minor version    : " + conn.getMetaData().getDatabaseMinorVersion());
  1. database Product Name     : Microsoft SQL Server
    database Product Version  : 11.00.2100
    database Major version    : 11
    database Minor version    : 0