Re: JDBC: Meta data: Invalid column type for DATE

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 11 Mar 2004 23:08:24 +0100
Message-ID: <c2qnt5$gkq$1@news1.tilbu1.nb.home.nl>

Tobias Besch wrote:

> In JDBC on Oracle tables with columns of type DATE:
>
> ResultSetMetaData.getColumnType(colNum) returns 91 which is wrong.
> DatabaseMetaData.getColumns() tells 93 which is right.
>
> Both ResultSetMetaData.getColumnTypeName(colNum) and
> DatabaseMetaData.getColumns() tell "DATE" which is wrong.
> The right type name for an Oracle DATE column would be "TIMESTAMP".

Versions?

Since 9i there are date as well as timestamp datatypes. And with, or without timezone... So maybe read the correct datatype, next time?

-- 

Regards,
Frank van Bortel

Received on Thu Mar 11 2004 - 16:08:24 CST