My Oracle Support Banner

GetColumns() Generates Java.lang.IllegalArgumentException: Cannot Set INT On Column With JDBC 12.2 (Doc ID 2390156.1)

Last updated on APRIL 25, 2018

Applies to:

JDBC - Version and later
Information in this document applies to any platform.


Application using JDBC (ojdbc8.jar) receives the following error when calling getMetaData().getColumns() in application to get type (java.sql.Types) of each column in the database.
This error does not present itself  with ojdbc6.jar or ojdbc7.jar.

java.lang.IllegalArgumentException: cannot set INT on column: LAST_ACTY_DAY_NBR

The column is defined as :





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.