AppletTalk.com Forum Index AppletTalk.com
Java discussions newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Oracle NUMBER and NUMBER(p) type - JDBC driver cannot see th

 
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases
View previous topic :: View next topic  
Author Message
Alexandr Molochnikov
Guest





PostPosted: Tue Jan 04, 2005 11:26 pm    Post subject: Oracle NUMBER and NUMBER(p) type - JDBC driver cannot see th Reply with quote



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


Back to top
Display posts from previous:   
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.