Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1407

Client code fails while inserting "lobs" in few situations

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 7.1.1, 7.3
    • 7.1, 7.2
    • JDBC Driver
    • 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.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            rhn-engineering-rareddy Ramesh Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: