"Invalid operation: Lob is closed" error when selecting from a DB2 Clob or Blob column in EDS
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, tools, and much more.