RE:

Sorry for the syntax problem :(.  That should be:

   rcdWLMLOGIN.setField("LSTACCDAT", bdLstAccDate.toBigDecimal());
   rcdWLMLOGIN.setField("LSTACCTIM", bdLstAccTime.toBigDecimal());

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary L Peskin
> Sent: Monday, May 12, 2003 11:35 AM
> To: 'Java Programming on and around the iSeries / AS400'
> Subject: RE: 
> 
> 
> Just to amplify slightly on ttufankj's answer, change the 
> last two lines to:
> 
>   rcdWLMLOGIN.setField("LSTACCDAT", bdLstAccDate).toBigDecimal();
>   rcdWLMLOGIN.setField("LSTACCTIM", bdLstAccTime).toBigDecimal();
> 
> The setField method doesn't handle com.ibm.math.BigDecimal objects.
> 
> HTH,
> Gary
> 
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> MEvans@xxxxxxxxxx
> > Sent: Monday, May 12, 2003 10:42 AM
> > To: java400-l@xxxxxxxxxxxx
> > Subject: 
> > 
> > 
> > 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")).retrieveR
> > ecordFormat
> > ();
> >                //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).t
> > oString());
> >                     BigDecimal bdLstAccTime =  new 
> > BigDecimal(DateUtil.getCurrentTime(DateUtil.MILITARY_FORMAT).t
> > oString());
> > 
> >                     //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(Http
> > Connection.java:57)
> >      at
> > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnec
> > tion.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.dispatchBy
> > URI(ServletRequestProcessor.java:190)
> >      at
> > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.serv
> > ice(OSEListener.java:406)
> >      at
> > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(Http
> > Connection.java:57)
> >      at
> > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnec
> > tion.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.dis
> > patch(ValidServletReferenceState.java:43)
> >      at
> > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispa
> > tch(ServletInstanceReference.java:41)
> >      at
> > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleW
> > ebAppDispatch(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
> 
> _______________________________________________
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>