Hello,

I have a float rounding problem with Hibernate which only appears with MySQL.

The problem is: when an object contains a float data type, values inserted in mysql are rounded to their closest integers.

For instance:

<class name="com.kertel.kercash.serialization.TarifUsingAppel" table="tarif">

....

<property name="amount" type="float" column="tari_montant" />

...

</class>

corresponding to this class:

public class TarifUsingAppel extends Tarif {
...
}

and

public class Tarif {
private float amount;
....
}


Saving such a class, into the table:

CREATE TABLE tarif (
tari_id int(11) NOT NULL default '0',
tari_montant float NOT NULL default '0',
PRIMARY KEY (tari_id)
) TYPE=MyISAM;

always transforms my floats into integers.

Browsing the net i found this on the mysql jdbc driver:

http://www.mysql.com/documentation/conn ... #id2802892

I use:

mysql version: MySQL 3.23.49-max-n
hibernate 2.0.2
jdbc drver: mysql-connector-java-2.0.14-bin.jar

Thank you for your ideas,
Adrian.

First, I would check if this rounding is happening when you use straight SQL to insert . Second, you may want to look at this.

Sorry, it was an error somewhere in my application it has nothing to do with Hibernate nor with the MySQL jdbc driver.

I could have sworn I saw this behavior several times (and I ignored them as MySQL is my test database) but I guess it's the same error that repeated several times.

Thanks for the URL, anyway; I also tried the direct JDBC insert, it worked: float in mysql accepts decimals so there's no problem there.

Best regards,
Adrian.

No, It actually do happens even when there is problem with SQL base .So you cann't consider it as your fault only




















____________________________________________________
SMS