[jira] [Closed] (CAY-2059) Detecting 'IS_AUTOINCREMENT' for columns in MS SQL Server

["Nikita Timofeev (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAY-2059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nikita Timofeev closed CAY-2059.
--------------------------------
    Resolution: Won't Fix

New SQLServer [driver|https://github.com/Microsoft/mssql-jdbc] supports {{IS_AUTOINCREMENT}} flag for SQLServer starting from v2012

> Detecting 'IS_AUTOINCREMENT' for columns in MS SQL Server
> ---------------------------------------------------------
>
>                 Key: CAY-2059
>                 URL: https://issues.apache.org/jira/browse/CAY-2059
>             Project: Cayenne
>          Issue Type: Bug
>    Affects Versions: 4.0.M2, 4.0.M3
>            Reporter: Savva Kolbachev
>            Assignee: Savva Kolbachev
>            Priority: Major
>
> Relates to the failed test DbLoaderIT.testLoad:187
> SQLServerResultSetMetaData doesn't return 'IS_AUTOINCREMENT' column. Furthermore, INFORMATION_SCHEMA.COLUMNS doesn't include 'IS_AUTOINCREMENT' column in MS SQL Server. So when we are trying to load DbAttributes in DbAttributesBaseLoader, we can not check and set correct value for generated columns.
> Detecting 'IS_AUTOINCREMENT' could be done by selecting 'is_identity' column from sys.columns. For example,
> http://stackoverflow.com/a/13772062/4819973
> http://stackoverflow.com/a/87993/4819973



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)