Hi Mead, thanks for the suggestion, but we want to keep the minimum changes on the code. if we convert into string in jsp/view pages, there are quite a lot of changes. however we already change our formatting script in our js library and it solved the issue.
also this issue just happend when we connect to SQL Server, it won't happend when we use Oracle DB. Thanks & Regards Yanto On Tue, Dec 7, 2010 at 11:07 AM, Mead Lai <[email protected]> wrote: > Hello, > > 1,convert the munber into string in the jsp/view page. > 2,write a JSTL to render that dataType by your self. > > Regards, > Mead > > > On Tue, Dec 7, 2010 at 10:25 AM, Yanto Bong <[email protected]> wrote: > > > Hi Li, > > > > thanks...unfortunately we already use this model in many places and we > need > > to have BigDecimal return datetype. > > However we already solve this issue by changing our java script lib. > > > > Thanks > > > > On Mon, Dec 6, 2010 at 11:47 AM, Li Ying <[email protected]> > wrote: > > > > > This looks like the result of toString() of BigDecimal. > > > > > > May be you can try this: > > > > > > > > > > > > http://download.oracle.com/javase/1.5.0/docs/api/java/math/BigDecimal.html#toPlainString%28%29 > > > > > > > > > > > > 2010/12/6 Yanto Bong <[email protected]>: > > > > Hi All, > > > > > > > > We've using BigDecimal as datatype in hibernate and model for Numeric > > > (20,8) > > > > datatype in database. > > > > however when we display it in JSP using struts 2, if the value <> 0 > > then > > > it > > > > will display correctly. > > > > However if the value is 0.00000000 in database, then it will display > in > > > JSP > > > > it will shown as *0E-8.00000000* > > > > > > > > anyone have this issue before ? > > > > > > > > Thanks & Regards > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [email protected] > > > For additional commands, e-mail: [email protected] > > > > > > > > >
