
March 28th, 2005, 04:35 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 27
Time spent in forums: 12 h 36 m 16 sec
Reputation Power: 0
|
|
comparing datatypes
hello,
i want to compare the datatypes of an access table and an oracle one.i'm connecting the oracle database using oracledriver.after comparison it is giving only date &text.how will i get the number data type?the code is like this..
for(int i=1;i<=Login.oraRsmd.getColumnCount();i++){
switch(Login.oraRsmd.getColumnType(i))
{
case java.sql.Types.VARCHAR:
oraColTypeVect.addElement("TEXT");
break;
case java.sql.Types.DATE:
case java.sql.Types.TIME:
case java.sql.Types.TIMESTAMP:
oraColTypeVect.addElement("DATE");
break;
it is comparing other columns not the number datatype.
if anybody can help plz
thanx in advance
|