Error Message Displays When Inserting or Updating a LOB Data Type Using Oracle 8i
 Technote (FAQ)
 
Problem
When using the LOB columns (BLOBs and CLOBs) with Oracle 8i, you can not use setCharacterStream or setBinaryStream to set BLOBs and CLOBs when the size of the LOB columns are greater than 4KB.

You receive one of the following error messages when inserting or updating a LOB (BLOBs and CLOBs) that are greater than 4KB, depending on the Oracle release:

"Data size bigger than Max size for this type: xxxx. SQL State = <null>, Error Code = 17,070"

"java.sql.SQLException: Io exception: End of TNS data channel SQL State: null Error Code: 17002"
 
Cause
Limitation of Oracle 8i driver
 
Solution
Oracle has lifted the restriction in the Oracle 9i Release 2 OCI JDBC Driver (or Thick driver). If you have one of these error messages or you know that your data exceeds 4KB, update to Oracle 9i Release 2 and use the Oracle OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i Release 2, please contact Oracle Support.

Note: This information can also be found in the WebSphere Application Server 5.0.1 Release Notes.

 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): Windows
Software version: 5.0.1
Software edition:
Reference #: 1113342
IBM Group: Software Group
Modified date: Aug 28, 2003