Mapping java.long to oracle.Number(14)

java oracle mapping sqldatatypes
x.509 picture x.509 · Oct 3, 2011 · Viewed 19.5k times · Source

I have db column whose datatype is Number (15) and i have the corresponding field in java classes as long. The question is how would i map it using java.sql.Types.

  • would Types.BIGINT work?
  • Or shall i use something else?

P.S: I can't afford to change the datatype within java class and within DB.

Answer

Mike picture Mike · Oct 3, 2011

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

Related questions

Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More
java.sql.SQLException: - ORA-01000: maximum open cursors exceeded

I am getting an ORA-01000 SQL exception. So I have some queries related to it. Are maximum open cursors exactly related to number of JDBC connections, or are they also related to the statement and resultset objects we have created …

Read More
Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our SQL variables to prepared statements and bind the variables instead. I am however facing a problem with the setDate(). Here …

Read More