Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> JDBC: Meta data: Invalid column type for DATE

JDBC: Meta data: Invalid column type for DATE

From: Tobias Besch <me_at_privacy.net>
Date: 6 Mar 2004 17:20:25 GMT
Message-ID: <Xns94A4BA8083B45tobiasbeschgmxde@ID-86573.user.dfncis.de> 





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".
Received on Sat Mar 06 2004 - 11:20:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US