Author: mikedd
Date: Thu Jan 13 22:00:14 2011
New Revision: 1058758
URL: http://svn.apache.org/viewvc?rev=1058758&view=rev
Log:
OPENJPA-1699: Add documentation for fully materialized LOB issue with streaming
LOBs and DB2
Modified:
openjpa/branches/2.0.x/openjpa-project/src/doc/manual/supported_databases.xml
Modified:
openjpa/branches/2.0.x/openjpa-project/src/doc/manual/supported_databases.xml
URL:
http://svn.apache.org/viewvc/openjpa/branches/2.0.x/openjpa-project/src/doc/manual/supported_databases.xml?rev=1058758&r1=1058757&r2=1058758&view=diff
==============================================================================
---
openjpa/branches/2.0.x/openjpa-project/src/doc/manual/supported_databases.xml
(original)
+++
openjpa/branches/2.0.x/openjpa-project/src/doc/manual/supported_databases.xml
Thu Jan 13 22:00:14 2011
@@ -622,6 +622,23 @@ of DESCSTAT, DB2 metadata tables must be
See DB2 for z/OS documentation for additional information.
</para>
</listitem>
+ <listitem>
+ <para>
+When using LOBs with persistent attributes of a streaming data type (e.g.
+<literal>java.io.InputStream</literal>) in the case of very large lob, DB2 JCC
+driver will automatically use progressive streaming to retrieve the Lob data.
+With progressiveStreaming, the inputStream retrieved must be fully
materialized
+before the next iteration of call to rs.next(). By default
+this will result in a LobClosedException when OpenJPA processes the
InputStream.
+ </para>
+ <para>
+To work around this condition you may force fullyMaterializedLobData to true
in
+the connection URL as shown below :
+<programlisting>
+openjpa.ConnectionURL:
jdbc:db2://localhost:50000/demodb:fullyMaterializeLobData=true;progressiveStreaming=NO
+</programlisting>
+ </para>
+ </listitem>
</itemizedlist>
</section>
</section>
