Info: DD connection to IBM DB - Password Issue

dtheimer

I came across this and thought I would share the information:
There might be a bug in either DataDeploy or IBM's Type 2 JBDC driver when the connection to the database is being made. If there is a "$" in the password field the connection is not made and the following error is found in the output:

>>> Loading drivers <<<
Loading COM.ibm.db2.jdbc.app.DB2Driver ..
url : bmdb
login : xxxxxx
login timeout=3
Connecting to the database...
Try connecting using jdbc:db2:bmdb...
SQL failure
ERROR:ERROR: Could not connect to [jdbc:db2:bmdb]

*******************************************************
SQLException occured in JdbcCheckup:MakeConnection()
Exception Message: [IBM][CLI Driver] SQL1403N The username and/or password supp
lied is incorrect. SQLSTATE=08004

Vendor Error Code: -1403
SQL state: 08004
*******************************************************

I did only very limited debugging by trying a different character such as the "@ and it worked in addition to the use of a number. But both times a $" was at the end of my password I received the above error.

i_like_smile

Hi,

If the '$' password is escaped using double '$', ie. if the password is wel$come then specify it as wel$$come in the database.xml it should work.
This will be documented in DD5.6 SP1 release note hopefully.

Thanks.