[ 
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)

Reply via email to