Hi,
I am using the DB2 Type 4 JDBC Driver to connect to my DB2 8.2 for
Windows server. Everything works perfectly unless I have a password
with the pipe character ( "|" ) in it. The server password has a "|"
character in it. If I do this, I get an exception stating that the
password is invalid.
This is what I execute ...
String password = "password|";
Connection conn = DriverManager.getConnection(url, "username",
password);
And this is the exception that I get ...
com.ibm.db2.jcc.b.SqlException: Connection authorization failure
occurred. Reason: password invalid.
The major and minor versions of the driver are 2.6. I can't seem to
find any other references on the web on this issue. Is this a known
limitation with the JDBC driver?
-Niels
aj - 02 Feb 2006 19:29 GMT
Interesting. I found the same behavior, but for an
exclamation point.
http://groups.google.com/group/comp.databases.ibm-db2/browse_thread/thread/1fa6b
5550c9ab3d9/db00c4aaae5bf616?lnk=st&q=password+aj+group%3Acomp.databases.ibm-db2
&rnum=1&hl=en#db00c4aaae5bf616
The only solution I found: change your password.
aj
> Hi,
>
[quoted text clipped - 20 lines]
>
> -Niels