473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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 2000
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ajay | last post by:
Hi, Could some please tell me whether Microsoft provides Type 2 and Type 4 jdbc driver ? For Type 4 MS provides com.microsoft.jdbc.sqlserver.SQLServerDriver driver. What is the cofiguration...
1
by: bogachkov | last post by:
Hello Joe Over the past several years, I have found your responses to jdbc usage/driver related issues to be extremely helpful. I am sure that you're very busy so I will make my question as...
4
by: Dani | last post by:
Hi everyone Description of the problem: Using a PreparedStatement to write down an integer (int) plus a timestamp for testing purposes. When read out again the integer looks very different. We...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
2
by: Neeraj | last post by:
Hii , We have DB2 7.1 on windows and we are trying to use a type 4 driver to connect to the data base . I have included the db2jcc.jar in the class path . I am able to create a connection to...
8
by: Rhino | last post by:
I'm trying to use the JDBC Universal driver to get a Type 4 connection in a Java client program running under DB2 V8.2.1 but I keep getting a "connection refused: connect" message. I'm running...
1
by: sbanil | last post by:
We have a JAVA application which uses following Database product name : DB2 Database product version : DSN07012 JDBC driver name : IBM DB2 JDBC Universal Driver Architecture JDBC driver version ...
2
by: %NAME% | last post by:
(Thanks to Bernd, Ian, Phil last time for their detailed answers last time) Now I try to call JDBC driver without giving the username and password as they suggested. I am using DB2 jdbc on SunOS...
3
by: Anoop | last post by:
Is it true that there are no type 4 jdbc drivers to connect to a DB2 server v7.1? The DB2 server is hosted on ACF2 (OS/390). We would be connecting from windows and solaris boxes. If it is true,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.