For more information about Oracle (NYSE:ORCL), visit. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! Retrieve BLOB column through application. The issue can be reproduced at will with the following steps:ġ. SQLState 99999, Error code 17004: : Invalid column type: getString not implemented for class 4CBlobAccessor This application code does not work against 12c database, but it does work against 10g database. : Invalid column type: getString not implemented for class 4CBlobAccessorĪt .unimpl(Accessor.java:412)Īt .getString(BlobAccessor.java:335)Īt .getString(OracleResultSetImpl.java:1118) The following error is received during its execution: Information in this document applies to any platform.Īpplication 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. TIP: Assuming you have installed the Oracle 11G rel2 client in the default location, then you can find this (on the Controller application server) here: C:\app\Administrator\product\11.2.0\client1\jdbc\lib. "Invalid column type: getString not implemented for class 4CBlobAccessor" When Retrieving BLOBs Use the ojdbc5.jar file (which comes from the Oracle 11G Rel2 client), because this is the version that is most tested 'in the field'.
0 kommentar(er)
