db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "fengrunlzk (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-267) Modify source database a column from nvarchar(1) to nvarchar(10), Platform.alterTables did not modify target database table column.
Date Fri, 03 Dec 2010 06:14:10 GMT
Modify source database a column from nvarchar(1) to nvarchar(10), Platform.alterTables did
not modify target database table column.
-----------------------------------------------------------------------------------------------------------------------------------

                 Key: DDLUTILS-267
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-267
             Project: DdlUtils
          Issue Type: Bug
          Components: Core - SqlServer
    Affects Versions: 1.0
         Environment: sql server 2000
            Reporter: fengrunlzk
            Assignee: Thomas Dudziak


Modify source database a column from nvarchar(1) to nvarchar(10), Platform.alterTables did
not modify target database table column to  nvarchar(10) .
And remove source database a column that has default value, Platform.alterTables target database
throw exception :
Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while executing
SQL ALTER TABLE acct_analysis_tab DROP COLUMN is_stop
	at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:331)
	at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:573)
	at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImplBase.java:507)
	at test.M.main(M.java:36)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: object 'DF__acct_anal__is_st__7E6CC920'
depends  column 'is_stop'。
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642)
	at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
	at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:309)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message