Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Jdbc specification on UNKNOWN data types?

843859Nov 28 2005 — edited Nov 28 2005
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2005
Added on Nov 28 2005
2 comments
278 views