|
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 |
|
|
|
|
|
|
|