IBM Support

Unable to query tables containing blob type column from DB Admin console

Troubleshooting


Problem

Selecting all columns against a table that contains a blob type attribute in the InfoSphere Master Data Management Collaboration Server (MDMCS) DB Admin console results in error message "error in trace"

Symptom

The query results are not retrieved successfully and following exception/stacktrace is found in the default.log of application server process.

2012-05-04 08:13:28,713 [jsp_28: /administration/adm_db_query_detail.jsp] ERROR jsp.adm_db_query_detail - CWPCM0001E:Generic error / Exception : , Exception:Invalid column type: getString not implemented for class oracle.jdbc.driver.T4CBlobAccessor

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:1251)

at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:198)

at administration.adm_db_query_detail._jspService(Unknown Source)

at com.ibm.ws.webcontainer.jsp.runtime.HttpJspBase.service(HttpJspBase.java:103)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1583)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1523)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)

at com.ibm.ccd.ui.filters.FuzaoRequestFilter.doFilter(Unknown Source)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)

at com.ibm.ccd.ui.filters.ResponseHeaderFilter.doFilter(Unknown Source)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)

at com.ibm.ccd.ui.filters.ResponseHeaderFilter.doFilter(Unknown Source)

at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)

at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)

at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:885)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:865)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:863)

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:182)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:288)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)

Cause

Oracle JDBC Driver 11g Release 2 (11.2) no longer supports getString method for retrieving BLOB column values

Resolving The Problem

Do not use "select *" and select only none-blob type columns in the select statement.
(OR)

Downgrade Oracle client to 11g R1

[{"Product":{"code":"SS2U2U","label":"InfoSphere Master Data Management Collaboration Server"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"10.0","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSLKUM","label":"InfoSphere Master Data Management Server for Product Information Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Troubleshooting","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.0;9.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Product Synonym

MDMCS;MDMPIM;MDM Server for PIM;WebSphere Product Center;InfoSphere MDM Server for PIM;InfoSphere Master Data Management Collaboration Server;InfoSphere Master Data Management Server for Product Information Management

Document Information

Modified date:
16 June 2018

UID

swg21596361

Page Feedback