Mapping of JDBC type BIGINT in SqlServerDialect

bcalmac · **Posted:** Thu Apr 01, 2004 10:57 pm

The SqlServerDialect (actually the base class SybaseDialect) maps the Types.BIGINT JDBC type to NUMERIC(19).

Is there any reason why it doesn't map it to the BIGINT type provided by SqlServer?

Beside using 1 byte less (BIGINT=8 bytes, NUMERIC(19)=9 bytes) the mapping to BIGINT is more natural (taking into account that it corresponds to java.lang.Long).

I know I can customize SQL type of the properties, but then the mapping file would not be portable among databases.

Thanks,
Bogdan Calmac
knoa software.

emmanuel · **Posted:** Fri Apr 02, 2004 1:31 pm

Extends you own dialect.