[no subject]

[MEvans@xxxxxxxxxx]

I'm having a problem updating a 8s0 field in an AS400 DB2 database using
RLA via the JTOpen Toolbox. I get a ClassCastException when the last two
lines of code execute.


 Below is a snippet of the code.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

               //Develop the file.
               // Create a record format instance for WLMLOGIN.
               RecordFormat[] fmtWFMLOGIN = (new
AS400FileRecordDescription(as400,
"/QSYS.LIB/GBTINET.LIB/WLMLOGINUP.FILE/%FILE%.MBR")).retrieveRecordFormat
();
               //Create a keyed file access instance for WLMLOGIN
               KeyedFile fileWLMLOGIN = new KeyedFile(as400,
"/QSYS.LIB/GBTINET.LIB/WLMLOGINUP.FILE/%FILE%.MBR");
               //Set the record format of file WLMLOGIN
               fileWLMLOGIN.setRecordFormat(fmtWFMLOGIN[0]);

               //Develop the key list.
               //Create an Object array that will represent the key list
for WLMLOGIN.
               Object[] keyWLMLOGIN = new Object[1];
               //Set the value of the keys
               keyWLMLOGIN[0] = UserName;

               //Open WLMLOGIN with a file access of Read and Write, One
record to retrieve, No commitment control to be used for the file.
               fileWLMLOGIN.open(AS400File.READ_WRITE, 1,
AS400File.COMMIT_LOCK_LEVEL_NONE);

               //Read the first record matching the key
               Record rcdWLMLOGIN = fileWLMLOGIN.read(keyWLMLOGIN);

               //If Record is not null then a match on the key was found.
               if (rcdWLMLOGIN != null)
               {
                    BigDecimal bdLstAccDate = new
BigDecimal(DateUtil.getCurrentDate(DateUtil.CCYYMMDD_FORMAT).toString());
                    BigDecimal bdLstAccTime =  new
BigDecimal(DateUtil.getCurrentTime(DateUtil.MILITARY_FORMAT).toString());

                    //Always update Last accessed date and time
                    rcdWLMLOGIN.setField("LSTACCDAT",(Object)
bdLstAccDate);
                    rcdWLMLOGIN.setField("LSTACCTIM", (Object)
bdLstAccTime);
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Here is the exception:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[5/12/03 14:19:59:986 NDT]  a618fb9 WebGroup      E SRVE0026E: [Servlet
Error]-[com.membersonly.servlet.LoginServlet]:
java.lang.ClassCastException: com.ibm.math.BigDecimal
     at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:57)
     at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:461)
     at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:414)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:614)
     at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:190)
     at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:406)
     at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:57)
     at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:461)
     at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:414)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:614)
     at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:414)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:614)
     at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:43)
     at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:41)
     at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:941)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:614)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Any help would be great. Thanks


Mark Evans
Programmer, Corporate Systems
Johnson Inc
Email....: mevans@xxxxxxxxxx