APAR status
Closed as program error.
Error description
The JPA provider included in WebSphere Application Server includes the parameter values from the prepared statements in its exception text.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM WebSphere Application * * Server Feature Pack for EJB 3.0 with Java * * Persistence API ( JPA ) applications. * **************************************************************** * PROBLEM DESCRIPTION: The OpenJPA JPA provider included with * * WebSphere Application Server logs * * SQL parameters when an exception * * occurs. * **************************************************************** * RECOMMENDATION: * **************************************************************** When a SQL exception occurs (e.g. inserting a new row) OpenJPA includes the SQL statement in the exception text in the log files. The values for any prepared statement parameters are included in this text by default.
Problem conclusion
The OpenJPA code has been updated to no longer print the parameter values by default, instead they will be masked with a ? character. If the old behavior is desired (this can be beneficial in development environments) the application may enable it by adding the following persistence property to persistence.xml : <property name="openjpa.ConnectionFactoryProperties" value="PrintParameters=true"/> The fix for this APAR is currently targeted for inclusion in fix pack 6.1.0.33. Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
Comments
APAR Information
APAR number
PM16563
Reported component name
WAS EJB3 FEATUR
Reported component ID
5724J0851
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-06-15
Closed date
2010-07-13
Last modified date
2010-07-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
WAS EJB3 FEATUR
Fixed component ID
5724J0851
Applicable component levels
R610 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
10 February 2022