Jdbc specification on UNKNOWN data types?
843859Nov 28 2005 — edited Nov 28 2005I need to access a column from informix table and it data type is interval?
How should jdbc respond in this case...
If I call
databasemetadata.getcolumn( "catalog", "schema", "table", null)
The table has first column which is of type interval,
ResultSet.next() throws an Unsupported data type SQL Exception.
Is this expected behaviour? Earlier it use to return a type code of 0 (java.sql.types).
What is expected here?
Does that mean, Jdbc cannot handle tables which has unknown data types of data types not supported by jdbc?
What is the OTHER data type then in java.sql.Types?
How should I handle in this in my code, I need to able to retrieve all the other data types?
Thanks,
Irfan.