469,352 Members | 1,982 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

DB2 Type 4 JDBC Driver - Support for passwords with "|"

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

Feb 2 '06 #1
1 1865
aj
Interesting. I found the same behavior, but for an
exclamation point.

http://groups.google.com/group/comp....00c4aaae5bf616

The only solution I found: change your password.

aj

ni*******@gmail.com wrote:
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

Feb 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Kent Lewandowski | last post: by
2 posts views Thread by Neeraj | last post: by
8 posts views Thread by Rhino | last post: by
2 posts views Thread by %NAME% | last post: by
3 posts views Thread by Anoop | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.