Forum Discussion

Copper Contributor

Aug 19, 2024

Arithmetic overflow error converting IDENTITY to data type bigint

Hello SQL experts, I have a legacy application developed when SQL server did not have native support for sequences. So what is does is creates table and uses its primary key as a sequence value gene...

syncfox

Copper Contributor

Aug 19, 2024

gyvkoff We are adding Java BigInteger support and hence we need underlying database to support this. Oracle supports this and has no issue. I assuming SQL Server's BIGINT is equivalent to Java's BigInteger data type.

gyvkoff

Brass Contributor

Aug 19, 2024

syncfox Unfortunately they do not correlate. SQL Server's BIGINT is a 64-bit signed integer, the equivalent is LONG in Java. If you need to support Java's BigInteger, then you'll need to use varbinary(n) or string like varchar(max).