PK85619: Java program ran on zOS USS fails due to encrypted password

Rational Business Developer Fix Pack 4 (7.1.0.4) for 7.1

APAR status

• Closed as program error.

Error description

• Environment:
  
   - Product name (Build ID or version/patch level): IBM Rational
  Business Developer v7.1.0.3
  Reproducible Y/N: Y
  
  Description of problem:
  
  
  When a Java program accessing DB2 is ran on zOS USS, a SQL conne
  ction error is raised when using encrypted password.
  It works with decrypted password in rununit properties.
  
  For example, if it is generated like
  
  vgj.jdbc.default.database.user.id=K#MARK
  vgj.jdbc.default.database.user.password=crypto:f123f3456cfa04e06
  01f30ab6d365853
  
  You need it to change it to
  
  vgj.jdbc.default.database.user.id=K#MARK
  vgj.jdbc.default.database.user.password=mypassword
  

Local fix

Problem summary

• By default, the EGL Java generator encrypts database
  passwords, and they are decrypted when they are needed as
  the program runs.  On systems that use an EBCDIC codepage,
  such as USS, database connections could not be made when the
  password is encrypted. Database connections only succeed
  when the password is not encrypted.
  

Problem conclusion

• Encrypted passwords are now decrypted properly on EBCDIC
  systems.
  

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

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R710 PSN

     UP