Silent (No Error) Truncation Reading a 4 GB or Larger BLOB with JDBC 11.2.0.1
(Doc ID 1101163.1)
Last updated on AUGUST 30, 2023
Applies to:
JDBC - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]Information in this document applies to any platform.
Symptoms
A java application reads BLOBs from a database and writes them to a file using the code:
When using JDBC 11.2.0.1 to read a 4 GB or larger BLOB from an 11.1.0.6 database, the output is truncated. There is no error.
However, when using JDBC 11.1.0.7 to read the same 4 GB or larger BLOB, truncation does not occur.
When using JDBC 11.2.0.1 to read a 4 GB or larger BLOB from a 10.2.0.3 database instead of from an 11.1.0.6 database, an "ORA-22925: operation would exceed maximum size allowed for a LOB value" error occurs. See <Note 1101087.1> "Reading a 3 GB BLOB with JDBC 11.2.0.1 Fails With "ORA-22925: operation would exceed maximum size allowed for a LOB value" for details.
Changes
The truncation occurred after upgrading JDBC 11.1.0.7 to JDBC 11.2.0.1.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |