java - Groovy number comparision issues -


i trying retrieve few values database , use them in groovy script in order find , compare differences.

an example below (when using float value in definition , in database defined number , precision 2), how output looks

>

typically seeing values expect both differences 16, not.

any suggestions on have missed ?

when numbers stored in database type of number(x,2) or similar, means getting exact numeric value 2 places after decimal. converting these floats introducing error (a small , bounded error, noticeable 1 have found out), because there not exact representation of these numbers. numbers when converted binary infinitely repeating , have truncated somewhere. bigdecimal represents numbers exactly, long don't construct them passing in floating point value, in case damage done before bigdecimal gets involved (all can @ point represent floating point approximation of original number). think using bigdecimal easy solution problem.

since it's groovy script assume performance not biggest consideration, if (and you're concerned garbage created instantiating bigdecimals) might consider delta approach suggested jb nizet. (see this article peter lawrey pointers on how work floating point numbers.) java's gc expects lot of ephemeral objects, it's not biggest performance problem.

there's question floats vs decimals here answers describe why floating-point not exact.


Comments

Post a Comment

Popular posts from this blog

asp.net mvc 3 - Using mvc3, I need to add a username/password to the sql connection string at runtime -

i see how build string using stringbuilders (sql/entity framework); do cause connection string used in dbcontext? example context: public class pophistorydbcontext : dbcontext { public dbset<pophistory> histories {get;set} } public class pophistoryrepository: ihistoryrepository { private pophistorydbcontext context = new pophistorydbcontext(); public iqueryable<pophistory> histories{ {return context.histories;} } } example usage in controller: public class historycontroller : controller { private ihistoryrepository repository = new pophistoryrepository(); var histories = h in repository.histories (h.modifytimestamp > today) select h; if (!string.isnullorempty(searchstring)) { histories = histories.where(h => h.dn.toupper().contains(searchstring.toupper())); } thank you
Read more

kineticjs - draw multiple lines and delete individual line -

i can draw multiple lines on canvas; added layer using drawscene dlayera1.add(line); line.getpoints()[0].x = mousepos.x; line.getpoints()[0].y = mousepos.y; line.getpoints()[1].x = mousepos.x; line.getpoints()[1].y = mousepos.y; moving = true; dlayera1.drawscene(); http://jsfiddle.net/user373721/xzead/1/ . is there way delete individual line? currently, you'll have modify points array this: line.getpoints()[0].splice(index, 1); since arrays modified reference, modifying returned array modifies "source of truth" points array attr
Read more

thumbnails - jQuery image rotate on hover -

any chance change image src on hover , count 10 , again first? this need, default thumb, flv-3.jpg ! <img src="/thumbs/e/b/d/6/d/ebd6d2d6d99e/ebd6d2d6d99e.flv-3.jpg" /> on mouse hover need change number flv-1.jpg flv-2.jpg flv-3.jpg flv-4.jpg etc.. up 10, , again , start number 1, when move mouse thumbs need default thumb flv-3.jpg this im use not solutions, var _thumbs = new array(); function changethumb(index, i, num_thumbs, path) { if (_thumbs[index]) { document.getelementbyid(index).src = path + + ".jpg"; preload = new image(); preload_image_id = (i + 1 > num_thumbs) ? 1 : + 1; preload.src = path + preload_image_id + ".jpg"; = % num_thumbs; i++; settimeout("changethumb('" + index + "'," + + ", " + num_thumbs + ", '" + path + "')", 800) } } function startthumbchange(index, nu
Read more