Re: JDBC & Passwords

["Mark Phippard" <MarkP@xxxxxxxxxxxxxxx>]

David,

You do not say which driver, but I will assume it is the Toolbox driver. 
Did you set that property that tells the driver not to use a GUI?  If not, 
it could be that it popped up a dialog box telling the user the password 
was going to expire in 5 days.  If this was in a service such as 
WebSphere, you might not even see the dialog anywhere.

I would give that a try.  If you do not know the property, I can look it 
up.

Mark







"David Gibbs" <david@xxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
03/17/2003 10:16 AM
Please respond to Java Programming on and around the iSeries / AS400 
 
        To:     java400-l@xxxxxxxxxxxx
        cc: 
        Subject:        JDBC & Passwords


I just ran into an odd situation ... had a user trying to connect to a 
V5R1
DB2 via JDBC.  When the program tried to connect, the program just hung. I
used opsnav to see if there was any connection at all, and found none.  I
saw in QHST that there was a "Signon" attempt, but nothing further.

I looked at the user profile and saw that it's password was scheduled to
expire in 5 days.  I set the PWDEXPITV value on the profile to *NOMAX and
had the user try to reconnect and it worked fine.

So obviously the password expiration had something to do with it ... 
anyone
know why a pending expiration would cause the database connection to hang?
It's as if the signon server was waiting for the user to decide if they
wanted to change their password or not.

Anyone know if there is a PTF out for this?  I searched the KB and found
nothing.

Thanks!

david


--
David Gibbs
david@xxxxxxxxxxxx


_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.