APAR status
Closed as program error.
Error description
Using WebSphere 5.0 data source with Oracle JDBC Driverversions
Local fix
There is no fix. The problem is with the limit on the setBytes
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server 5.0 users with *
* session persistence to Oracle, or users *
* doing their own persistence to an Oracle *
* database. *
****************************************************************
* PROBLEM DESCRIPTION: Oracle has a limitation of 4K for its *
* setString and setBytes methods. If *
* setString or setBytes is used for *
* data larger than 4K, an ORA-01461 *
* exception occurs. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
To avoid the ORA-01461 exception, customers can use the
setCharacterStream or setBinaryStream methods for setString
and setBytes respectively. However, in an effort to make
the database vendor transparent from the code, we will
modify our setString and setBytes methods to check the size
of the data and use setCharacterStream and setBinaryStream
for large data.
Problem conclusion
Modified setString and setBytes to handle Oracle data larger
than 4K transparently. This will allow session persistence
and customer applications to execute without special code for
Oracle.
Temporary fix Comments
APAR information |
APAR number |
PQ77056 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00A |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-08-01 |
Closed date |
2003-08-25 |
Last modified date |
2003-08-25 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSN |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|