FIX: An error may occur when you try to use the JDBC driver to insert binary large object data into a SQL Server 2000 table (823896)

SYMPTOMS

When you try to insert binary large object (BLOB) data into a Microsoft SQL Server 2000 table by using the Microsoft SQL Server 2000 Driver for JDBC, and then you set the network packet size configuration option of the sp_configure system stored procedure to a value that is larger than 4096, you may receive the following error message:

[Microsoft][SQLServer 2000 Driver for JDBC]End of stream was detected on a read.
[Microsoft][SQLServer 2000 Driver for JDBC]Connection aborted by peer: socket write error

RESOLUTION

To resolve this problem, obtain the latest service pack for SQL Server 2000 Driver for JDBC. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

883370 Information about how to obtain the latest SQL Server 2000 Driver for JDBC service pack

For additional information about how to obtain a hotfix for this problem, click the following article number to view the article in the Microsoft Knowledge Base:

817326 FIX: JDBC driver may cause application to stop responding during multiple transactions

STATUS

Microsoft has confirmed that this is a bug in SQL Server 2000 Driver for JDBC version 2.20.0029 for Service Pack 1.

This bug was corrected in SQL Server 2000 Driver for JDBC version 2.20.0030 for Service Pack 1.

MORE INFORMATION

You may use the following code to set the network packet size configuration option of the sp_configure system stored procedure:

EXEC sp_configure 'network packet size', 8192
RECONFIGURE WITH OVERRIDE
GO

REFERENCES

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:

network packet size Option
http://msdn.microsoft.com/library/en-us/adminsql/ad_config_6svi.asp

RECONFIGURE
http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_54kl.asp