AppletTalk.com

Guest

When I save some numbers (i.e. 5987.24) hibernate saves it to my
database correctly (SQL Server) but when it retrives it, it's changing
the value slightly (5987.240234375).

I'm using hibernate 3 on Windows XP Pro.

I've queried the database in between saves and retrives and verified
the number is saved correctly. I have no idea how this is happening.

When I used 5987.9 hibernate came back with a slightly lower value;
5987.899......

Using 12.0 hibernate worked correctly; it returned 12.0.

-------- from TruckLoadout.hbm.xml ------------
<property name="grossPounds" type="java.lang.Double">
<column name="GrossPounds" precision="12" scale="2" />
</property>
<property name="netPounds" type="java.lang.Double">
<column name="NetPounds" precision="12" />
</property>
--------------------------------------------------------------

I added the scale attribute to gross pounds. No effect. Apparently it's
only used by tools to build a database from the xml anyway.

Both netPounds and gross pounds have a precision of 12 and scale of 2
in my database.

I'm using the JTDS driver.

------------------- The code used to retrieve the
data-----------------------------
public TruckLoadout read(Integer equipmentId) {
TruckLoadout result = new TruckLoadout();
try {
org.hibernate.Session hibernateSession =
HibernateSessionFactory.currentSession();
Criteria criteria =
hibernateSession.createCriteria(TruckLoadout.class);
Criterion fieldName = Expression.eq("equipmentId", equipmentId);
criteria.add(fieldName);
result = (TruckLoadout)criteria.uniqueResult();
}
catch(Exception ex) {
ex.printStackTrace();
}
finally {
//Close the session
try {
HibernateSessionFactory.closeSession();
} catch (Exception ex) {
ex.printStackTrace();
}
}

return result;
}
----------------------------------------------------------------------------------------

Again, I've looked at the data between the time hibernate stores it in
the database and when it's retrived and it is stored correctly (without
the long drawn out digits).

-------------------- From AbstractTruckLoadout.java
--------------------------
private Double grossPounds;
private Double netPounds;

/** full constructor */
public AbstractTruckLoadout(Date arrivalDt, Date startLoadingDt,
Date endLoadingDt, Double grossPounds, Double netPounds, Double
tarePounds, Integer consigneeId, Integer equipmentId) {
this.arrivalDt = arrivalDt;
this.startLoadingDt = startLoadingDt;
this.endLoadingDt = endLoadingDt;
this.grossPounds = grossPounds;
this.netPounds = netPounds;
this.tarePounds = tarePounds;
this.consigneeId = consigneeId;
this.equipmentId = equipmentId;
}

public Double getGrossPounds() {
return this.grossPounds;
}
public void setGrossPounds(Double grossPounds) {
this.grossPounds = grossPounds;
}
public Double getNetPounds() {
return this.netPounds;
}
public void setNetPounds(Double netPounds) {
this.netPounds = netPounds;
}

Lee Fesperman · Guest

KevinLEdwards (AT) gmail (DOT) com wrote:

Guest

Thank you Lee, that did it.

Lee Fesperman wrote: