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>