can java's Long hold a SQL BIGINT(20) value?

java sql bigint
prime picture prime · Jul 27, 2015 · Viewed 11k times · Source

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

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

(I thought of using Long but there is BigInteger also, can't figure out what is good or suitable)

Answer

Leland Barton picture Leland Barton · Jul 27, 2015

It depends on the database server. A Java long is always implemented as 8 bytes since it is part of the standard.

On MSSQL, the bigint type is 8 bytes, so it is a perfect match.

Related questions

How to convert java.util.Date to java.sql.Date?

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date. I was surprised to find that it couldn't do the conversion implicitly or explicitly …

Read More
could not extract ResultSet in hibernate

I have a problem with Hibernate. I try to parse to List but It throws an exception: HTTP Status 500 - could not extract ResultSet. When I debug, It fault at line query.list()... My sample code here @Entity @Table(name = "…

Read More
Hibernate show real SQL

if I set <property name="show_sql">true</property> in my hibernate.cfg.xml configuration file in the console I can see the SQL. But it's not real SQL... Can I see the SQL code that …

Read More