You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "Christoffer Hammarström (JIRA)" <ji...@apache.org> on 2006/07/11 18:53:32 UTC

[jira] Created: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
-------------------------------------------------------------------------------------------------------

         Key: DDLUTILS-115
         URL: http://issues.apache.org/jira/browse/DDLUTILS-115
     Project: DdlUtils
        Type: Bug

  Components: Core  
 Environment: MSSQL
    Reporter: Christoffer Hammarström
 Assigned to: Thomas Dudziak 


When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=comments#action_12420361 ] 

Christoffer Hammarström commented on DDLUTILS-115:
--------------------------------------------------

Sorry, that patch was against an older version of ddlutils. Making a new one now.

> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Commented: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=comments#action_12420363 ] 

Christoffer Hammarström commented on DDLUTILS-115:
--------------------------------------------------

... and, it's even fixed in the latest version. Sorry for the spam. Please close this.



> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Resolved: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ]
     
Thomas Dudziak resolved DDLUTILS-115:
-------------------------------------

    Resolution: Fixed

> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Updated: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Christoffer Hammarström (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ]

Christoffer Hammarström updated DDLUTILS-115:
---------------------------------------------

    Attachment: DDLUTILS-115.patch

This patch fixes the bug by causing ddlutils to issue "SET IDENTITY_INSERT" statements.

> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Updated: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ]

Thomas Dudziak updated DDLUTILS-115:
------------------------------------

    Component: Core - SqlServer

> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core - SqlServer
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

[jira] Updated: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ]

Thomas Dudziak updated DDLUTILS-115:
------------------------------------

    Component:     (was: Core (No specific database))

> SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.
> -------------------------------------------------------------------------------------------------------
>
>          Key: DDLUTILS-115
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-115
>      Project: DdlUtils
>         Type: Bug

>   Components: Core - SqlServer
>  Environment: MSSQL
>     Reporter: Christoffer Hammarström
>     Assignee: Thomas Dudziak
>  Attachments: DDLUTILS-115.patch
>
> When trying to make a column in a table longer, Ddlutils uses a table copy. This only works on tables without identity columns.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira