Skip to Main Content

Java Database Connectivity (JDBC)


For appeals, questions and feedback about Oracle Forums, please email 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?

Post Details
Added on Nov 2 2022
1 comment