[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1407) Client code fails while inserting "lobs" in few situations

Client code fails while inserting "lobs" in few situations ---------------------------------------------------------- Key: TEIID-1407 URL: https://issues.jboss.org/browse/TEIID-1407 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.1, 7.2 Reporter: Ramesh Reddy Assignee: Ramesh Reddy Priority: Critical Fix For: 7.1.1, 7.3 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.