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.


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


View raw message