Preparedstatement.Setbinarystream() Does Not Read All The Data From The Stream (Doc ID 1091238.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

PreparedStatement.setBinaryStream() does not read all the bytes in the stream. Consequently only partial data is stored in the database.
The issue is in the JDBC driver which does not read the stream until end of file or even the length supplied. It reads as long as its buffer is filled, which is not guaranteed by the contract of InputStream.read()
Supplying an InputStream that always fills the buffer does work correctly. Using setBytes() does work because it supplies all the content right away, however this will not work with streams that are too large to be loaded into a byte array in memory.
The end result is that you may find that the BLOB stored in the database is smaller than the size of the stream used by the PreparedStatement.setBinaryStream().

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.