I am using Hibernate with JPA annotations on my POJO's and was until recently having trouble getting Hibernate to recognize the money type reported by MS SQLServer 2005:

@Column(name = "purchase_price", scale = 4)
@Type(type="big_decimal")
public BigDecimal getPurchasePrice() {
return this.purchasePrice;
}

The only way I could figure out how to do this was to extend the SQLServerDialect in order to support the type as follows:

/*
* Custom class extending SQLServerDialect to recognize money data type
*/
public class MyDialect extends SQLServerDialect {

public MyDialect() {
super();
registerColumnType( Types.NUMERIC, "money" );
}
}

and configure Hibernate to use it instead of SQLServerDialect. Is there a more elegant way to achieve the same result in either the Hibernate configuration or using JPA annotations on the attribute? If there is a way to do this using hbm.xml mappings, I would like to hear about it also.

Thanks for any help,
Bernard