"Invalid operation: Lob is closed" error when selecting from a DB2 Clob or Blob column in EDS

Solution Verified - Updated -

Issue

  • we are trying to import the data from DB2 Data Source (with BLOB & CLOB column) through EDS, but get the below error when trying to query it:
2013-10-29 18:18:01,475 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue40) Unexpected exception for session DpiBfReZK5wB
java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.62.56] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
    at org.teiid.dqp.internal.process.LobWorkItem.createLobStream(LobWorkItem.java:133)
    at org.teiid.dqp.internal.process.LobWorkItem.run(LobWorkItem.java:71)
    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:244)
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:122)
    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:292)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10120][11936][3.62.56] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null
    at com.ibm.db2.jcc.am.fd.a(fd.java:660)
    at com.ibm.db2.jcc.am.fd.a(fd.java:60)
    at com.ibm.db2.jcc.am.fd.a(fd.java:94)
    at com.ibm.db2.jcc.am.he.d(he.java:67)
    at com.ibm.db2.jcc.am.le.x(le.java:419)
    at com.ibm.db2.jcc.am.le.getCharacterStream(le.java:268)
    at org.teiid.core.types.ClobType.getCharacterStream(ClobType.java:68)
    at org.teiid.dqp.internal.process.LobWorkItem.createLobStream(LobWorkItem.java:128)
    ... 7 more

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1
  • Roll up patch EDS_5.3.1_3_2013

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In