Wednesday 13 November 2013

database error: "NUMERIC scale x must be between 0 and precision y"

Error message when saving with JPA BigDecimal with @Column(precision = 1, scale = 2):

"NUMERIC scale 2 must be between 0 and precision 1"

The reason+solution: scale must be less than precision (i.e. scale=2 must be less than pression=1)


Reference
https://mariadb.com/kb/en/numeric-data-types/

No comments:

Post a Comment