JPA mapping a Java Double to a SQL Number column

Question

I have the following SQL definition for a table which i can't change ``` CREATE TABLE network_model_property ( id NUMBER NOT NULL PRIMARY KEY, name VARCHAR2(100) NOT NULL, .... max NUMBER(10), min NUMBER(10), .... ) ``` The JPA'ed class definition is as following ``` @Entity @Table(name = "network_model_property") @SequenceGenerator(name = "PropertySeq", sequenceName = "MODEL_PROPERTY_SEQUENCE") public class ModelProperty implements Serializable { static final long serialVersionUID = -3276944825572313129L; @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "PropertySeq") @Column(name = "id") private Long id; @Column(name = "max") private Double max; @Column(name = "min") private Double min; public Double getMax() { return max; } public void setMax(Double max) { this.max = max; } public Double getMin() { return min; } public void setMin(Double min) { this.min = min; } ``` I'm running a simple test case which throws this exception when 'hibernate.hbm2ddl.auto=validate'…

Accepted Answer

In your table definition, the max and min columns have a precision specified, but no scale. Try using scale = 0 on your Column JPA definition for the max & min properties.

JPA mapping a Java Double to a SQL Number column

Solution

Problem