Originally, whenever the database password expires, jConnect for JDBC would throw an exception to the client, and would suggest to change the password using isql. With the password expiration handling feature, jConnect handles the expired password exceptions and changes the password internally. jConnect for JDBC introduces two new connection properties to support this feature—PROMPT_FOR_NEWPASSWORD and NEWPASSWORD.
When a client password expires, jConnect checks the value of PROMPT_FOR_NEWPASSWORD to determine whether to do a transparent password change or to prompt for the new password. If this property is set to True, a dialog box pops up and the user is prompted to set the new password manually. If PROMPT_FOR_NEWPASSWORD is set to False, jConnect checks the value of NEWPASSWORD and, if NEWPASSWORD is not null, uses this value to replace the expired password.
The default value of PROMPT_FOR_NEWPASSWORD is false while the default value of NEWPASSWORD is null.
