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. Please ask technical questions in the appropriate category. Thank you!

Why ResultSetMeta.getColumnType returns a wrong value(-101, -102)

User_TPQV6Nov 2 2022

when a column type is TIMESTAMP WITH TIME ZONE or TIMESTAMP WITH LOCAL TIME ZONE, the ResultSetMeta.getColumnType will return -101 or -102, but the -101 or -102 are not standard values defined in the java.sql.types.
However, this interface ResultSetMeta.getColumnType claims that it will return a java.sql.types value.

is THIS a bug?

Comments
Post Details
Added on Nov 2 2022
1 comment
151 views