[jboss-dev-forums] [Design of the JBoss EJB Container] - Date Error while running Core Banking application

[rajesh_cbe2000]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4149002#4149002

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4149002