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

Technote (troubleshooting)


Problem(Abstract)

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


Cross reference information
Segment Product Component Platform Version Edition
Information Management InfoSphere Master Data Management Server for Product Information Management Troubleshooting AIX, HP-UX, Linux, Solaris 9.0, 9.1 All Editions

Product Alias/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

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Master Data Management Collaboration Server

Software version:

10.0

Operating system(s):

AIX, Linux, Solaris

Software edition:

All Editions

Reference #:

1596361

Modified date:

2012-11-02

Translate my page

Machine Translation

Content navigation