Unable to update/insert Table's CLOB column via Odata4 restful.
Issue
In my Mysql database, a table has a TEXT(CLOB) type column.
But I failed to update/insert this value via Odata4 restful approach, error shows:
Caused by: java.sql.SQLException: java.io.IOException: JBWEB000059: Stream closed
at org.teiid.core.types.ClobImpl.getSubString(ClobImpl.java:171) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
at org.teiid.core.types.ClobType.getSubString(ClobType.java:77) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
at com.mysql.jdbc.PreparedStatement.setClob(PreparedStatement.java:3529)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:4098)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3981)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.setObject(WrappedPreparedStatement.java:957)
at org.teiid.translator.jdbc.JDBCExecutionFactory.bindValue(JDBCExecutionFactory.java:965)
at org.teiid.translator.jdbc.JDBCBaseExecution.bind(JDBCBaseExecution.java:107)
at org.teiid.translator.jdbc.JDBCUpdateExecution.executeTranslatedCommand(JDBCUpdateExecution.java:262)
... 20 more
Caused by: java.io.IOException: JBWEB000059: Stream closed
at org.apache.catalina.connector.InputBuffer.read(InputBuffer.java:391) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
at org.apache.catalina.connector.CoyoteInputStream.read(CoyoteInputStream.java:193) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1]
at java.nio.channels.Channels$ReadableByteChannelImpl.read(Channels.java:385) [rt.jar:1.8.0_151]
at org.teiid.core.util.InputStreamReader.read(InputStreamReader.java:80) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
at org.teiid.core.util.ObjectConverterUtil.write(ObjectConverterUtil.java:159) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
at org.teiid.core.util.ObjectConverterUtil.convertToCharArray(ObjectConverterUtil.java:316) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
at org.teiid.core.types.ClobImpl.getSubString(ClobImpl.java:166) [teiid-common-core-8.12.13.6_3-redhat-1.jar:8.12.13.6_3-redhat-1]
... 28 more
Environment
- Red Hat JBoss Data Virtualization 6.3.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.