Alexandr Molochnikov Guest
|
Posted: Tue Jan 04, 2005 11:26 pm Post subject: Oracle NUMBER and NUMBER(p) type - JDBC driver cannot see th |
|
|
One of our customers reported a problem that was traced to the table field
attributes returned by
DatabaseMetaData.getColumns(). The DECIMAL_DIGITS value for NUMBER and
NUMBER(p) fields is 0, making it impossible to diffrenciate between these
two types. However, the NUMBER type carries floating point values, and
NUMBER(p) carries integers. Yet the JDBC driver cannot tell them apart.
Does anyone know of some way to detect NUMBER data type and distinguish it
from the other variety?
TIA
Alex Molochnikov
Gestalt Corporation
|
|