You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Phee, Martin J (Jump Tech)" <Ma...@bp.com> on 2002/06/28 17:23:26 UTC

Problems deleting

I'm having a problem deleting a record.  The record has a column defined as
a Decimal(4,3).  It's an oracle database.  The record isn't deleting when I
call doDelete after doing a retrieve of the record.  I traced it to this.
If you look below the where clause is all screwed up.  The value should only
be 0.20

BasePeer.doDelete:
whereClause=OWN_PCT=0.200000000000000011102230246251565404236316680908203125
AND SHIPPER_CUST_ID=1234 AND TANK_ID=14302

When I tried the above in sqlplus I confirmed it wouldn't delete the record
until I changed the value of own_pct.

What gives?  Any idea's?  The value is defined as a BigDecimal in the om
class. 

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>