problem with JDBC metadata getColumnType() returning float

From: Deb McCamish <dmccamish_at_columbus.rr.com>
Date: Mon, 06 Dec 1999 05:21:56 GMT
Message-ID: <UJH24.3111$Ih4.39565@typhoon.columbus.rr.com>

i have the following code after a theResultSet.next():

java.sql.ResultSetMetaData sqlMetaData = theResultSet.getMetaData(); int theType = sqlMetaData.getColumnType(1);

when the column is a float, the type is *NOT* set to java.sql.Types.FLOAT, but it is set to java.sql.Types.NUMERIC.

is this a bug or am i doing something wrong? the other types like varchar and date are correct from getColumnType();

i'm running Oracle 8.1.5, Oracle JDBC thin driver and JDK 1.1.6. Received on Sun Dec 05 1999 - 23:21:56 CST