PI28233: UPDATING A DATASOURCE PROPERTY VALUE OF TYPE #BOOLEAN CAUSES A NEW DATASOURCE TO BE ADDED AS TYPE #STRING WHEN USING WSADMIN

8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
8.5.5.21: WebSphere Application Server V8.5.5.21

APAR status

• Closed as program error.

Error description

• Create a new boolean data source using the administrative
  console.
  Navigate to:
  Resource > JDBC > Data sources > [DATASOURCE] > Custom
  Properties
  name="deferPrepares"
  type="java.lang.Boolean"
  value="false"
  Modity the value of the property using wsadmin, extracting
  the properties to create a server1.props file
  >wsadmin
  AdminTask.extractConfigProperties('[-propertiesFileName
  server1.props -configData Server=server1]')
  -
  looking in the server1.props at the data sources we can see
  that the value is set to false and resources.xml shows the
  same.
  -
  If we try to change the value of the data source property from
  true to false by changing the server1.props file
  server1.props
  ----------------
  deferPrepares=true #Boolean
  ----------------
  Using type #Boolean instead of type #boolean
  -
  >wsadmin
  AdminTask.applyConfigProperties('[-propertiesFileName
  server1.props]')
  AdminConfig.save()
  --
  If we export out the properties again it has not changed our
  original entry but has added a new data source in the
  resources.xml file as type #String
  -
  server1.props
  ----------------
  deferPrepares=false #boolean
  deferPrepares=true #String
  

Local fix

• Workaround would be to use the Admin Console to remove the
  added data resource of type string
  If changing the value for the boolean, use type #boolean instead
  of type #Boolean, when using wsadmin.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server Property File Based Configuration    *
  *                  (PFBC)                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Using wrong case for data type          *
  *                      already created can cause duplicate     *
  *                      properties to be created.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Using the wrong case for a data type can cause unexpected
  behavior.
  

Problem conclusion

• The PFBC code was changed to handle any capitalization for any
  type when dealing with properties.
  
  The fix for this APAR is currently targeted for inclusion in
  fix packs 8.0.0.11 and 8.5.5.5.  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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R800 PSY

     UP

• R850 PSY

     UP