[ http://issues.apache.org/jira/browse/DDLUTILS-51?page=all ]
Thomas Dudziak resolved DDLUTILS-51.
------------------------------------
Resolution: Fixed
This works now, DdlUtils will not change the column if you run the schema
against the database again:
[ddlToDatabase] INFO: Executed 0 SQL command(s) with 0 error(s)
> BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT
> --------------------------------------------------------
>
> Key: DDLUTILS-51
> URL: http://issues.apache.org/jira/browse/DDLUTILS-51
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - SqlServer
> Environment: WinXP Pro, SQL-Server 2000, java 1.4.2
> Reporter: Colin Ritchie
> Assigned To: Thomas Dudziak
> Priority: Minor
> Fix For: 1.0
>
>
> Columns for MS-SQL with Type BOOLEANINT get the following error when using
> the ant task writeSchemaToDatabase:
> [ddlToDatabase] INFO: Altering column oci_schedules.schd_state
> [ddlToDatabase] INFO: desired = Column [name=schd_state; javaName=null;
> type=TINYINT; typeCode=-6; size=null; required=false; primaryKey=false;
> autoIncrement=false; defaultValue=null; precisionRadix=0; scale=0]
> [ddlToDatabase] INFO: current = Column [name=schd_state; javaName=null;
> type=SMALLINT; typeCode=5; size=5; required=false; primaryKey=false;
> autoIncrement=false; defaultValue=null; precisionRadix=5; scale=0]
> The following is a snippet of my configuration file:
> <table name="oci_schedules">
> <column name="schd_state" primaryKey="false" required="false"
> type="BOOLEANINT" autoIncrement="false"/>
> </table>
--
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
