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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1407?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-1407.
---------------------------------



> 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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira