Hibernate version: 3
Name and version of the database you are using: SQL Server 2005

I'm trying to map to the SQL Server column type decimal(15,7). I have hbm2ddl.auto set to validate. Using straight java & hibernate double produces error:

org.hibernate.HibernateException: Wrong column type: price, expected: double precision

and using long produces the error:

org.hibernate.HibernateException: Wrong column type: price, expected: numeric(19,0)

and using BigDecimal/big_decimal produces the error:

org.hibernate.HibernateException: Wrong column type: price, expected: numeric(19,2)

but if I add precision="15" scale="7" it becomes:

org.hibernate.HibernateException: Wrong column type: price, expected: numeric(15,7)


I must be missing something simple. All thoughts and advice appreciated.

Thanks