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