[jira] Commented: (OPENJPA-1248) LOB streaming does not work as expected

["Milosz Tylenda (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENJPA-1248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12796006#action_12796006 ] 

Milosz Tylenda commented on OPENJPA-1248:
-----------------------------------------

Modified SQLServerDictionary to use ResultSet.getBlob.getBinaryStream (and its CLOB counterpart). Unfortunately, this poses a problem similar to the one with MySQL - when reading LOB contents, the whole contents are actually brought into memory. Added a note on the limitation to the user manual.

ResultSet.getBinaryStream provides true streaming but suffers from the problem described earlier.

I did not check whether streaming actually takes place when writing LOB contents to the database. Also, I tried only MS 2.0 driver.

Now the LOB streaming tests pass with all 4 databases.


> LOB streaming does not work as expected
> ---------------------------------------
>
>                 Key: OPENJPA-1248
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1248
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 1.1.0, 1.2.0, 1.2.1, 1.3.0, 2.0.0
>         Environment: Oracle, MySQL, PostgreSQL, SQL Server
>            Reporter: Milosz Tylenda
>         Attachments: failures.txt, TestReaderLob_oracle.log
>
>
> TestReaderLob does not pass with any of the databases indicated in the test case: Oracle, MySQL, PostgreSQL, SQL Server. TestInputStreamLob passes only with MySQL and PostgreSQL.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.