ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wu, Daniel" <Daniel...@smss.sony.com>
Subject Strange data/number clobbered problem
Date Wed, 27 Jan 2010 00:32:58 GMT


We recently encountered some issues which potentially related to iBitis.

We searched the web and the mailing list archive but did not find
anything useful so far.  I am submitting this to the mailing list to see
if anyone has encountered this problem before and/or maybe point me some


We are using iBatis or our production environment.  It is a
java web application deployed to a farm of tomcat 5.5.27.  On one
instance of the tomcat farm, the decimal point of numerical value was
clobbered; the rest of the instances in the farm seems to be ok.  To
troubleshoot, we isolated the instance and hot deployed new modified web

app in the same tomcat container.      The modified app is compiled from

same branch of source code but we added some logging and a jsp page to
allow us to run ad-hoc sql query.  


The modified app still shows the wrong numerical value, but the value is
correct when we did direct sql execution through the jsp page.  We
turned on the logging java.sql.* and saw the logging output that we
believe is coming from iBatis:


2010-01-26 19:59:11,889 [TP-Processor6] DEBUG java.sql.ResultSet -
{rset-100101} Result: [30453, New Releases $9.99 , 9.99 price for new
releases, N, 0, 0.0, 2009-04-03 02:00:00.0, 2012-04-03 19:00:42.0,

2009-04-03 19:00:53.0, 2010-01-18 21:18:12.0, SSD]


Where the 0.0 supposed to be 9.9.  The pattern of the issue is that the
decimal point is shifted in the value, for example 15.95 becomes 159.5.


We are currently stuck because we don't want to bounce the instance and
we are not exactly sure how to trigger issue.  We can only suspect that
there are some funny thing going on between iBatis and jdbc.  


Again, please let me know if you have seen this issue.  Thank you in


Daniel Wu


To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org

View raw message