|
Problem IC97527
|
Status: Closed |
CLPPLUS WILL THROW A JCC EXCEPTION WHEN CONNECTION FAILS TO ESTABLISH AND 'WHENEVER SQLERROR' CLAUSE IS SET. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
CLPPlus will throw a JCC exception when it encounters invalid
user name, password, instance port or connection is simply
refused. It is preferred that CLPPlus when 'whenever
sqlerror' clause is set acts accordingly to define action.
>clpplus
CLPPlus: Version 1.6
Copyright (c) 2009, 2011, IBM CORPORATION. All rights reserved.
SQL> WHENEVER SQLERROR EXIT
SQL> CONNECT username/password@localhost:50000/db_name
[jcc][t4][2043][11550][3.64.114] Exception
java.net.ConnectException: Error
opening socket to server localhost/127.0.0.1 on port 50,000 with
message:
Connection refused. ERRORCODE=-4499, SQLSTATE=08001
Enter DATABAE NAME [db_name]:
Above is an example of JCC exception that is side effect of
wrongly entered instance port. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V10.5 CLPPLUS users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.5 Fix Pack 3 or higher to solve this *
* issue. *
**************************************************************** |
| Local Fix: |
No local fix is available. |
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
The problem has been first fixed in DB2 v105fp_dec |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.11.2013
28.02.2014
28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
