[
https://issues.apache.org/jira/browse/OPENJPA-1248?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12794679#action_12794679
]
Milosz Tylenda commented on OPENJPA-1248:
-----------------------------------------
Looking closer at MySQL reveals its limitations. When reading LOB contents, the
whole contents are actually brought into memory. Chances are this can be worked
around in:
1. MySQLDictionary.getLOBStream / getCharacterStream.
2. Modifying column list in SELECT.
Details can be found in MySQL docs [1]. For now I have added a note on the
limitation to the user manual.
Not sure whehter a similar limitation exists when writing LOB contents to the
database.
[1]
http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-implementation-notes.html
> 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.
