"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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
