Numerics and Decimals in mysql 5

jdijkmeijer Dec 23, 2006 11:17 AM

Hi I'm using seam-gen (seam 1.1GA) and jboss 4.0.5 GA non clustered ejb3 together with mysql.
In de createdb script of mysql I create a colum like amount NUMERIC(10,2), looking at it by desc table shows decimal (10,2). MySQL chooses not to use numerics but decimals instead. What's in a name.
seam generate-entitiies works fine, but the scale is omitted, no problem I can add that by hand. However with the added scale I still get an expected numeric exception on deployment, I checked the dialect (mysql) and I'm a bit lost at this moment. Nor do I see any reference to this problem, which makes me wonder whether I'm doing something very unusual (unlikely numerics are widely used at my work (oracle)), or very stupid...?
any help would be appreciated.

(mysql 5.02, jboss 4.0.5GA seam1.1GA, winxp sp2).

regards,
Jeroen.

1. Re: Numerics and Decimals in mysql 5

norman.richards Dec 23, 2006 11:29 AM (in response to jdijkmeijer)

This is a known problem with hibernate. The simplest workaround, is to add columnDefinition="decimal(10,2)" to your @Column annotation. Hibernate will validate the field correctly, but it will have no other impact on your code.
Actions