|
Problem IC95296
|
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: *
* CLPPLUS users. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Please See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Please See Error Description. *
**************************************************************** |
| Local Fix: |
No local fix is available. |
| available fix packs: |
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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
02.10.2013
02.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
