Details
-
Bug
-
Resolution: Done
-
Critical
-
7.1, 7.2
-
None
-
Medium
Description
There were few different lob issues surfaced while inserting a blob into database using the Teiid.
1) Using "javax.sql.rowset.serial.SerialBlob" to construct a blob, and using stmt.setBlob(int, blob) on prepared statement ended up with "broken pipe" error and terminated the client connection when the blob size was bigger than a 1 MB.
2) Using "org.teiid.core.types.ClobImpl" with constructor " new ClobImpl(int, InputStreamFactory)" resulted in the java.io.NotSerializableException: exception.
3) Using simple stmt.setBlob(int, inputstream), also ended up with same java.io.NotSerializableException: exception.
Currently only option is to use (1) and making sure that Objects are not bigger than 1 MB.