Mapping java.long to oracle.Number(14) Mapping java.long to oracle.Number(14) oracle oracle

Mapping java.long to oracle.Number(14)


From this link it says that java.sql.Types.BIGINT should be used for long in Java to Number in SQL (Oracle).

Attaching screenshot of the table in case the link ever dies.

SQL and JDBC datatypes


A good place to find reliable size mappings between Java and Oracle Types is in the Hibernate ORM tool. Documented in the code here, Hibernate uses an Oracle NUMBER(19,0) to represent a java.sql.Types.BIGINT which should map to a long primitave


I always use wrapper type, because wrapper types can be express null values.

In this case I will use Long wrapper type.