APAR status |
Closed as program error.
| Error description
The situation using SQLJ and application DB
UDB6.1/OS390 through DB2connect.
If connection pooling are time out , the next
new DB connection spawn SQL58004. The result is
the DB connection is not available with following
error till WAS restart.
.
01.03.29 10:56:22:277 JST 9a68ce43 ServletInsta
n X Uncaught service() exception thrown by servlet
{0}: {1}
"honda.jp.hm.obt.servlets.OBLILI00Se
rvlet"
javax.servlet.ServletException: OBT20
02E unexpected error occuered on DB. Keep a copy o
f exhibited error message and contact HelpDesk.
SQLSTATE=58004,SQLCODE=-99999, IBM CLIDriver CLI
0119E An unexpected system error occurred. SQLSTA
TE=58004 at honda.jp.hm.obt.servlets.OBLILI00Serv
let.performTask(OBLILI00Servlet.java:179)
at honda.jp.hm.obt.servlets.OBLILI00Servlet.doG
et(OBLILI00Servlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpS
ervlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpS
ervlet.java:853)
.
.
.
.
So the SQLSTATE=58004 is out of handling. Local fix
add the following code to
com.ibm.ejs.cm.portability.DB2PortabilityLayer
// Fix for ErrorCode:CLI0119E SQLstate:58004 (SQLJ,DB2/390)
errorMap.put("58004", StaleConnectionException.class); Problem summary
CLI0119E An unexpected system error occurred SQLSTATE 58004
when the connection pool has timed out. Problem conclusion
com/ibm/ejs/cm/portability/DB2PortabilityLayer.java
was changed to add StaleConnectionException mapping for DB2
layer: SQLState 58004 Temporary fixComments
APAR information | APAR number | PQ48194 | Reported component name | WAS STANDARD AI | Reported component ID | 5648C8300 | Reported release | 350 | Status | CLOSED PER | PE | NoPE | HIPER | NoHIPER | Submitted date | 2001-04-27 | Closed date | 2001-05-08 | Last modified date | 2001-05-08 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:APAR is sysrouted FROM one or more of the following:
Modules/Macros APAR is sysrouted TO one or more of the following:Modules/Macros
|
Fix information |
Fixed component name | WAS STANDARD AI | Fixed component ID | 5648C8300 |
Applicable component levels | R350 PSY | UP |
|