Hi,
I have Java application running on Websphere Application Server 6.0 This application connects to Mainframe DB2 using CLI type 2 driver. The application uses websphere connection pool mechanism.
I have stored procedures which are called from the application and one particular stored procedure call throws the below error:
SystemErr R SQL exception: com.ibm.websphere.ce.cm.StaleConnectionException: [IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003
SystemErr R Exception occurred in CodeServlet.performTaskFind: java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: ; nested exception is:
java.lang.Error: Illegal ConnectO state: DESTROYED
Before the above errors seen on SystemErr, I see the db2 logs have the below trace.
2007-01-25-09.31.52.093982 Instance:db2 Node:000
PID:123456(java) TID:3195 Appid:GAE02875.C8FA
DRDA Application Requester sqljrParseMrspReply2 Probe:150 ADM2503C A datastream parsing error has been detected. A dump has been
generated.
2007-01-25-09.31.52.141257-480 I265922C348 LEVEL: Error
PID : 712746 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
APPID : GAE02875.C8FA
FUNCTION: DB2 UDB, DRDA Application Requester, sqljrParseMrspReply2, probe:150
RETCODE:ZRC=0x8037008D=-2143879027=SQLJR_SYNTAX "SYNTAX ERROR"
2007-01-25-09.31.52.160111-480 I266271C642 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
APPID : GAE02875
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -30020 sqlerrml: 17
sqlerrmc: 0x124C"("0100")"
sqlerrp : sqljrexr
sqlerrd : (1) 0x8037008D (2) 0x0000008D (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2007-01-25-09.31.52.160270-480 I266914C172 LEVEL: Error
PID : 123456 TID : 3195 PROC : java
INSTANCE: db2 NODE : 000
APPID : GAE02875.C8FA
FUNCTION: DB2 UDB, SQO Memory Management, sqlofmblkEx, probe:22
MESSAGE : Attempted to free NULL pointer.
CALLSTCK:
[0] 0xD3104E94 sqlofmblkEx + 0x8E4
[1] 0xD2CDFAEC sqljrFreeMrspObjects__FP18db2UCRtnResSetInfo + 0x98
[2] 0xD30A3048 sqljrParseMrspReply2__FP7UCintfcUsP19SQLJR_CURSORP IDLIST + 0xD94
[3] 0xD30A02A8 sqljrParseExecuteReply__FP7UCintfc + 0x4720
[4] 0xD3060138 sqljrParse__FP7UCintfc + 0x1C4
[5] 0xD3011ED8 sqljrDrdaArExecute__FP7UCintfcP9UCstpInfo + 0x830
[6] 0xD2D793E0 CLI_sqlCallProcedure__FP17CLI_STATEMENTINFOP19CLI_ ERRORHEADERINFO + 0x320
[7] 0xD2D959CC SQLExecute2__FP17CLI_STATEMENTINFOP19CLI_ERRORHEAD ERINFO + 0xE48
[8] 0xD2D933F8 SQLExecute + 0xBC8
[9] 0xD0B2E760 ?unknown + 0xFFFFFFE7
I have checked the parameters sent to stored procedure and everything is correct.I do not have this problem on a development server but the issue is in only a User Acceptance test server.
Any help would be greatly appreciated.
Thanks