empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele (Resolved) (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] [Resolved] (EMPIREDB-105) Support of long integer fields on MS SQL Server
Date Mon, 10 Oct 2011 15:03:29 GMT

     [ https://issues.apache.org/jira/browse/EMPIREDB-105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rainer Döbele resolved EMPIREDB-105.
------------------------------------

    Resolution: Fixed

The size of an column of datatype INTEGER or AUTOINC can be specified with the size parameter.

This can be DEFAULT, SMALLINT or BIGINT.

Inside a DBTable class you may write:

// DEFAULT (usually 4 bytes = 32bit)
DEPARTMENT_ID   = addColumn("DEPARTMENT_ID",    DataType.INTEGER,      DEFAULT,  true);

// SMALLINT (usually 2 bytes = 16bit)
DEPARTMENT_ID   = addColumn("DEPARTMENT_ID",    DataType.INTEGER,      SMALLINT,  true);

// BIGINT (usually 8 bytes = 64bit)
DEPARTMENT_ID   = addColumn("DEPARTMENT_ID",    DataType.INTEGER,      BIGINT,  true);

This is consistent over all drivers.
However the exact interpretation of INT, SMALLINT an BIGINT is left to the DBMS. 

                
> Support of long integer fields on MS SQL Server
> -----------------------------------------------
>
>                 Key: EMPIREDB-105
>                 URL: https://issues.apache.org/jira/browse/EMPIREDB-105
>             Project: Empire-DB
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: empire-db-2.1.0-incubating
>         Environment: Microsoft SQL Server
>            Reporter: Eric Cournarie
>            Assignee: Rainer Döbele
>             Fix For: empire-db-2.2.0-incubating
>
>
> Same bug as EMPIREDB-100 , but for Microsoft SQL Server. The DBDatabaseDriverMSSQL does
not handle the different integer sizes

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message