Michelle, You can use DECIMAL or NUMERIC types.
<column sql-type="DECIMAL" scale precision length/> Quoting Michelle Caisse <[EMAIL PROTECTED]>: > TestFieldsOfDouble fails because the test attempts to persist values of > Double.MIN_VALUE and Double.MAX_VALUE and the Derby double datatype has > narrower limits: > > "DOUBLE value ranges: > > * Smallest DOUBLE value: -1.79769E+308 > * Largest DOUBLE value: 1.79769E+308 > * Smallest positive DOUBLE value: 2.225E-307 > * Largest negative DOUBLE value: -2.225E-307 > > These limits are different from the java.lang.DoubleJava type limits." > > Any suggestions on how to handle this? > > -- Michelle >