0 Replies Latest reply on May 7, 2008 3:15 AM by Rajesh S

    Date Error while running Core Banking application

    Rajesh S Newbie

      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