APAR status
Closed as program error.
Error description
As a user of WebSphere Application Server, JDBC, and the Oracle JDBC driver when I use third-party libraries or applications that are written in a general manner for non-specific database calls, I find that I often have an over-abundance of DSRA8207I messages in my messages.log file. This is caused by the library or application inappropriately calling con.setReadOnly(false) which the oracle driver does not support. Since this is logged each time this method is called on a connection it could lead to the messages.log file increasing to an undesirable size.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server * **************************************************************** * PROBLEM DESCRIPTION: DSRA8207I is logged to messages.log * * each time con.setReadOnly(false) is * * called while using an Oracle * * datasource. * **************************************************************** * RECOMMENDATION: * **************************************************************** The Oracle JDBC driver does not support setting read-only to false. If a customer has a third-party application that is written for generic JDBC calls they will see the DSRA8207I message for each connection.
Problem conclusion
WebSphere Application Server will now log this informational message once the first time it occurs and then be traced only as a debug message from then on. The fix for this APAR is targeted for inclusion in fix pack 8.5.5.25 and 9.0.5.18. For more information, see 'Recommended Updates for WebSphere Application Server': https://www.ibm.com/support/pages/node/715553
Temporary fix
Comments
APAR Information
APAR number
PH57293
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
900
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-10-02
Closed date
2023-11-13
Last modified date
2023-11-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 November 2023