Java to DB2 data types Mapping

[Andres G.]

Hi,

I'm working in something related to DB to Java data types mapping and
I'm not sure which java types should I use for the following DB2 types:

DECIMAL -> Should I use Double?
DOUBLE -> Should I use Double?
GRAPHIC -> ?????
LONG VARGRAPHIC -> ?????
REAL -> Should I use Double?
TIME -> java.sql.Time -> java.util.?????
TIMESTAMP -> ?????
VARGRAPHIC -> ?????

Thanks in advance.

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I'm working in something related to DB to Java data types mapping and
I'm not sure which java types should I use for the following DB2 types:

http://publib.boulder.ibm.com/infoc...om.ibm.db2.udb.apdv.java.doc/doc/rjvjdata.htm

Arne

 

[Andres G.]

Thanks

http://publib.boulder.ibm.com/infoc...m..ibm.db2.udb.apdv.java.doc/doc/rjvjdata.htm

Arne

 

[Tim Slattery]

Hi,

I'm working in something related to DB to Java data types mapping and
I'm not sure which java types should I use for the following DB2 types:

DECIMAL -> Should I use Double?
DOUBLE -> Should I use Double?
REAL -> Should I use Double?

For these it depends on how much precision you need as opposed to how
much size. If you need many digits of precision you might need Java's
BigDecimal. If you need only a few digits precision but you need to
represent extremely large (10**30) or extremely small (10**-30), maybe
double would be a better fit.

GRAPHIC -> ?????
LONG VARGRAPHIC -> ?????
VARGRAPHIC -> ?????

Don't know what these are, but I doubt that Java has anything that
really corresponds. Check the Blob interface, you might find something
there that would help.

TIME -> java.sql.Time -> java.util.?????
TIMESTAMP -> ?????

I expect the Java Time object would work here.

--
Tim Slattery
(e-mail address removed)

 

[Lee Fesperman]

I'm working in something related to DB to Java data types mapping and
I'm not sure which java types should I use for the following DB2 types:

DECIMAL -> Should I use Double?
DOUBLE -> Should I use Double?
GRAPHIC -> ?????
LONG VARGRAPHIC -> ?????
REAL -> Should I use Double?
TIME -> java.sql.Time -> java.util.?????
TIMESTAMP -> ?????
VARGRAPHIC -> ?????

The standard (JDBC) mapping would be:

DECIMAL -> java.math.BigDecimal
DOUBLE -> Double
REAL -> Float
TIME -> java.sql.Time
TIMESTAMP -> java.sql.Timestamp
GRAPHIC, LONG VARGRAPHIC, VARGRAPHIC -> likely byte[]