TechNote (Archived)

JTOpen JDBC driver hangs when a bad user name or password is sent to the database

Issue

---

When using IBM's opensource JTOpen JDBC driver to connect Macromedia ColdFusion MX to DB2 running on an iSeries (formerly AS/400), the ColdFusion MX server may hang if a bad username or password is sent to the database. When this occurs, a restart of the ColdFusion service is required and, in some cases, a reboot of the server.

Solution

---

A JDBC URL parameter called prompt can be used in this case. As explained in the IBM Toolbox for Java JDBC properties documentation, the parameter functions as follows:

The parameter specifies whether the user should be prompted if a user name or password is needed to connect to the server. If a connection can not be made without prompting the user, and this property is set to "false", then an attempt to connect will fail.

To solve this problem, you should append the "prompt=false" parameter to the data source JDBC URL. This will allow an appropriate error to be returned if a bad user name or password is sent to the database.

For example, specify the following for the JDBC URL:

 jdbc:as400://[Server Name or IP]/[Database Name];prompt=false; 

Search Support

---