IJ44864: PSDI.MBO.SQLFORMAT ERROR - SETSTRING METHOD IS MENTIONED IN JAVADOC, BUT IT IS NOT ACCESSIBLE

APAR status

• Closed as program error.

Error description

• Problem description:
  
  psdi.mbo.SqlFormat error - setString method is mentioned in
  Javadoc, but it is not accessible
  
  Steps to reproduce:
  
  Review the 7.6.1.2 SQL Format
  
  
  class: psdi.mbo.SqlFormat
  method: appendStatement
  
  The method description is:
     public SqlFormat appendStatement(java.lang.String statement)
     Allows for dynamically building a query with binds
  (especially without a mbo). Ie, when you append a query like
     sql.appendStatement(" and field = :1 ").setString(1,"test");
     Parameters:
         statement -
  
  
  This statement is broken down into this:
     sql.appendStatement(" and field = :1 ") - returns a SQLFormat
  object
  .setString(1,"test"); - this makes a call on the SQLFormat
  object
  
  The problem is that the setString method is not publicly
  declared on the object so the documented call cannot be
  executed. Looking at the code the method is present but it is
  not publicly declared.
  
  It looks like developers should be using setObject.
  
  
  Expected behavior:
  
  
  The documentation should give sample code that can be used.
  
  Actual behavior: (include screenshots if it makes it easier to
  explain what is wrong):
  
  
  The documentation gives code that can't be used
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Give Sql Format setString() a public accessible modifier to  *
  * be consistent with setBoolean(), setLong() etc so that       *
  * customers can call this method in their customizations.      *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.x Product
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels