A fix is available
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 number
PK85619
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-04-29
Closed date
2009-07-24
Last modified date
2009-07-24
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
07 December 2021