"Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor" When Retrieving BLOBs (Doc ID 2132601.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

Application using JDK 1.5 and 11.2.0.4 ojdbc5.jar connects to 12c database (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) and retrieves information from BLOB columns.

The following error is received during its execution:

java.sql.SQLException: Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:412)
at oracle.jdbc.driver.BlobAccessor.getString(BlobAccessor.java:335)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1118)

 This application code does not work against 12c database, but it does work against 10g database.


ERROR
-----------------------
SQLState 99999, Error code 17004: java.sql.SQLException: Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Retrieve BLOB column through application.
2. The error is received.

Changes

Cause

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