db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Colin Ritchie (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-51) BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT
Date Mon, 28 Nov 2005 17:09:37 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-51?page=comments#action_12358678 ] 

Colin Ritchie commented on DDLUTILS-51:
---------------------------------------

The problem is that the column created is TINYINT, so the attempted ALTER happens every time.
 I believe it is related to the BOOLEANINT being mapped to SMALLINT in the base API, and SMALLINT
being mapped to TINYINT is the MSSQL API.

> BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT
> --------------------------------------------------------
>
>          Key: DDLUTILS-51
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-51
>      Project: DdlUtils
>         Type: Bug
>  Environment: WinXP Pro, SQL-Server 2000, java 1.4.2
>     Reporter: Colin Ritchie
>     Assignee: Thomas Dudziak
>     Priority: Minor

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


Mime
View raw message