3.2.2:

Using SQLServer 2000

Hey Ho,

Am trying to use the updateSchema tool to.... update my schema.

Taking the following definition


Update schema runs fine but creates the column with a datatype of float. Being as floats are approximate numbers only and should be used as the storage type of last resort (especially with financial systems), I was hoping to see it be stored as numeric(15,6).

Seems the only way to do this is to define the entry as:



The overhead comes here in having to create the column name mapping twice along with the nested <column...> entry (picky aint I?)

Twas my vague hope, that having a pojo with a Double type and specifying precsion and scale would create the table structure using a more precise storage value that a float.

Am I barking up the wrong tree with the way I'm going about this?

tia

How about using the hibernate type 'big_decimal'?

<property name="OpenPrice" type="big_decimal" precision="15" scale="6">

I think this would work even if your POJO is using Double and not java.math.BigDecimal.

-Mark

Cheers Mark, worked a treat.

Hmm, have to take that back. It worked great for creating/altering the schema, but when reading it back, HIB expected the datatype to be a bigDecimal. Just took me a while to notice....

Will keep on it...