Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

scale error while trying to insert record into sybase table

10 views
Skip to first unread message

Jagan

unread,
Aug 31, 2001, 1:05:25 PM8/31/01
to
When i try to insert a record into Sybase table thru a view, i am
getting the following exception:
-------------------------------
8/31/2001 9:48:17 com.sybase.jdbc2.jdbc.SybSQLException: Scale error
during implicit conversion of NUMERIC value '3.3399999141693115234375'
to a DECIMAL field.

at java.sql.SQLException.<init>(SQLException.java:45)
at com.sybase.jdbc2.jdbc.SybSQLException.<init>(SybSQLException.java:73)
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java(Compiled Code))
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java(Compiled Code))
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1479)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1462)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:411)
at com.ibm.ejs.cm.proxy.StatementProxy.executeUpdate(StatementProxy.java:152)
at ucfy.tax.dataaccessobject.VWesstransw4view.insert(VWesstransw4view.java:98)
at ucfy.tax.ejb.TaxManagerBean.updateTax(TaxManagerBean.java:248)
at ucfy.tax.ejb.EJSRemoteTaxManager.updateTax(EJSRemoteTaxManager.java:35)
at ucfy.tax.ejb._TaxManager_BaseStub.updateTax(_TaxManager_BaseStub.java:303)
at ucfy.tax.ejb._TaxManager_Stub.updateTax(_TaxManager_Stub.java:60)
at ucfy.tax.controller.TaxController.updateTax(TaxController.java:723)
at ucfy.tax.controller.TaxController.handleUcfyTaxWHChangeReview(TaxController.java:361)
at ucfy.tax.controller.TaxController.process(TaxController.java:52)
at ucfy.base.servlet.BaseServlet.processRequest(BaseServlet.java:118)
at ucfy.base.servlet.BaseServlet.doPost(BaseServlet.java:69)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:626)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:160)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:287)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:105)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:360)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:775)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:701)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:478)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:234)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:138)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:77)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:106)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:160)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:300)
at com.ibm.servlet.engine.oselistener.SQEventListenerImp$ServiceRunnable.run(SQEventListenerImp.java:230)
at com.ibm.servlet.engine.oselistener.SQEventListenerImp.notifySQEvent(SQEventListenerImp.java:104)
at com.ibm.servlet.engine.oselistener.serverqueue.SQEventSource.notifyEvent(SQEventSource.java:212)
at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.notifyService(SQWrapperEventSource.java:353)
at com.ibm.servlet.engine.oselistener.serverqueue.SQWrapperEventSource$SelectRunnable.run(SQWrapperEventSource.java:220)
at com.ibm.servlet.engine.oselistener.outofproc.OutOfProcThread$CtlRunnable.run(OutOfProcThread.java:248)
at java.lang.Thread.run(Thread.java:481)

8/31/2001 9:48:17 ; nested exception is:
com.sybase.jdbc2.jdbc.SybSQLException: Scale error during implicit
conversion of NUMERIC value '3.3399999141693115234375' to a DECIMAL
field.

------------------------

It is very urgent as the system is going into production. Any help
deeply appreciated.
thanks

Jagan

0 new messages