Date Error while running Core Banking application
We have developed Core Banking Application on JBoss 3.2.3
Application Server with IBatis Frame work. When we run the End of Day process
in the application the following error message is displayed on the JBOSS
Console "Cause: java.lang.ClassCastException" .
However once we restart the JBOSS server and rerun the End of Day process the
error does not recur. We wish to point out that we made no change in the
application, but just restarting the JBOSS server is clearing the error.
I've pasted the server.log contents when the error is displayed. I've also
pasted that server log contents after restarting the JOBSS server.
server.log with Error
=====================
2008-05-05 12:26:58,656 INFO [STDOUT] @@@@@@@@@@@@$$%^^%where{INST_DT=null, ACT_NUM=LA00000032, STATUS=CREATED,
INST_TYPE=null, PBOOKFLAG=0, TRANS_DT=Wed Sep 28 00:00:00 GMT+05:30 2005, TRANS_ID=C0000654, AUTHORIZE_DT=Wed Sep 28 00:00:00
GMT+05:30 2005, AUTHORIZE_STATUS=AUTHORIZED, INSTRUMENT_NO2=null, PARTICULARS=BY CASH, CREDIT=45000.0, INSTRUMENT_NO1=null,
BALANCE=-1211987.0}
2008-05-05 12:26:58,656 DEBUG [com.ibatis.db.sqlmap.MappedStatement] executeUpdate: insertPassBook
2008-05-05 12:26:58,656 DEBUG [java.sql.Connection] {conn-105603} Connection
2008-05-05 12:26:58,656 ERROR [com.ibatis.db.sqlmap.MappedStatement] Error executing 'insertPassBook' in
'com/see/truetransact/transferobject/transaction/transfer/TxTransferMap.xml'. Check the Parameter Map (or inline parameters).
Check the 'TRANS_DT' property. Cause: java.lang.ClassCastException
java.lang.ClassCastException
at com.ibatis.db.sqlmap.MappedStatement.executeUpdate(Unknown Source)
at com.ibatis.db.sqlmap.SqlMap.executeUpdate(Unknown Source)
server.log Without Error
========================
2008-05-05 13:14:32,406 INFO [STDOUT] @@@@@@@@@@@@$$%^^%where{INST_DT=null, ACT_NUM=LA00000032, STATUS=CREATED,
INST_TYPE=null, PBOOKFLAG=0, TRANS_DT=Wed Sep 28 00:00:00 GMT+05:30 2005, TRANS_ID=C0000654, AUTHORIZE_DT=Wed Sep 28 00:00:00
GMT+05:30 2005, AUTHORIZE_STATUS=AUTHORIZED, INSTRUMENT_NO2=null, PARTICULARS=BY CASH, CREDIT=45000.0, INSTRUMENT_NO1=null,
BALANCE=-1211987.0}
2008-05-05 13:14:32,453 DEBUG [com.ibatis.db.sqlmap.MappedStatement] executeUpdate: insertPassBook
2008-05-05 13:14:32,453 DEBUG [java.sql.Connection] {conn-102318} Connection
2008-05-05 13:14:32,453 DEBUG [java.sql.PreparedStatement] {pstm-102319} PreparedStatement: INSERT INTO PASS_BOOK (ACT_NUM,
TRANS_DT, PARTICULARS, INSTRUMENT_NO1, INSTRUMENT_NO2, DEBIT, CREDIT, BALANCE, PBOOK_FLAG, SLNO ,TRANS_ID,BATCH_ID,
INST_TYPE,INST_DT,STATUS,AUTHORIZE_STATUS, AUTHORIZE_DT, PAGENO, CREATED_DT) VALUES (?, ?, ?, ?, ?, ?, ?,?,?,DECODE((SELECT
NVL(MAX(SLNO)+1,1) FROM PASS_BOOK WHERE ACT_NUM =? AND PAGENO = (SELECT NVL(MAX(PAGENO),1) FROM PASS_BOOK WHERE ACT_NUM
=?)),31,1,(SELECT NVL(MAX(SLNO)+1,1) FROM PASS_BOOK WHERE ACT_NUM =? AND PAGENO = (SELECT NVL(MAX(PAGENO),1) FROM PASS_BOOK
WHERE ACT_NUM =?))),?,?,?,?,?, ?, ?,DECODE((SELECT NVL(MAX(SLNO),1) FROM PASS_BOOK WHERE ACT_NUM =? AND PAGENO = (SELECT
NVL(MAX(PAGENO),1) FROM PASS_BOOK WHERE ACT_NUM =?)), 30,(SELECT NVL(MAX(PAGENO)+1,1) FROM PASS_BOOK WHERE ACT_NUM =?),
(SELECT NVL(MAX(PAGENO),1) FROM PASS_BOOK WHERE ACT_NUM =?)),SYSDATE)
2008-05-05 13:14:32,453 DEBUG [java.sql.PreparedStatement] {pstm-102319} Parameters: [LA00000032, 2005-09-28, BY CASH, 12,
12, 2, 45000.0, -1211987.0, 0, LA00000032, LA00000032, LA00000032, LA00000032, C0000654, 12, 12, 91, CREATED, AUTHORIZED,
2005-09-28, LA00000032, LA00000032, LA00000032, LA00000032]
===========================================================================================
Can you kindly advise the source of the problem. Is it problem with Application Server or Coding or Data? In both the logs
the TRANS_DT property contains same data ("Wed Sep 28 00:00:00 GMT+05:30 2005") only.
Regards,
Rajesh.S