incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele <>
Subject re: how to use bigint integers
Date Wed, 22 Dec 2010 15:01:17 GMT
Hi Eike,

your suggested solution is exactly the one I would recommend.
(Besides I would suggest to make the condition "size>=8" rather than "size==8")

I cannot test postgre SQL, but if you send us your implementation of appendColumnDesc we will
check it and change our implementation accordingly.

Thanks and regards,

Eike Kettner wrote:
> from: Eike Kettner []
> to:
> re: how to use bigint integers
> Hello,
> I have a question regarding the integer type and ddl script generation.
> I'm using empire-db with postgre-sql and apache derby. I'd like the
> primary keys to be BIGINT and not INT and I didn't find a good way how
> to tell empiredb when to use BIGINT and when to use INT - the datatype
> is DataType.INTEGER and the drivers for postgre and derby do always say
> INT (not sure about the newest trunk version).
> What I do is overwriting the method
>  boolean appendColumnDesc(DBTableColumn c, StringBuilder sql, boolean
> alter)
> of the DBDatabaseDriver class and checking for an given size. So a
> column with DataType.INTEGER and size=8 is then created as BIGINT.
> Did I miss something, or how would you recommend to address this?
> Thanks in advance
> Eike

View raw message