Can java Hold SQL BIGINT (20) value?

Question

I have a table in an SQL database where the data type of the values is BIGINT (20) and I need to get this data for my logic in Java for processing.

What should be the appropriate data type in java to store the return value of BIGINT (20)?

(I was thinking about using Long, but there is BigInteger also, I can’t figure out which is good or suitable)

+4

prime Jul 27 '15 at 15:19

3 answers

Leland barton · Answer 1 · 2015-07-27T15:23:34+0000

It depends on the database server. Java is longalways implemented as 8 bytes, as it is part of the standard.

In MSSQL, the type bigintis 8 bytes, so it is perfect.

Jan de Vos · Answer 2 · 2015-07-27T16:09:34+0000

BIGINT SQL, , . , , MSSQL, MySQL, Oracle, Postgresql IBM DB2 , 8 ( , DB2 64- ).

Java Long 64 , . longs , BigIntegers, .

Rishabh kashyap · Answer 3 · 2015-07-27T15:25:50+0000

Long - perfect mapping for a large Int database