SQL : Put schema constraints into bean model

[Timo Westkämper]

 Put schema constraints into bean model in annotation form (nullability, size, regex constraints ?!?)

[Timo Westkämper (timo-westkamper)]

The annotation set to be used would be the annoations for Bean Validation : http://relation.to/Bloggers/BeanValidationSneakPeekPartI

[Timo Westkämper (timo-westkamper)]

Here is a mapping from the DatabaseMetaData getColumns values

COLUMN_SIZE -> @Max(n)
NULLABLE columnNoNulls -> @NotNull

[Timo Westkämper (timo-westkamper)]

Take depencency from here : http://repository.jboss.org/maven2/javax/validation/validation-api/1.0.CR3/

[Timo Westkämper (timo-westkamper)]

Currently Max and NotNull are used. Feel free to suggest additions :

@Table("EMPLOYEE")
public class Employee {

    @Column("DATEFIELD")
    private java.sql.Date datefield;

    @Max(50)
    @Column("FIRSTNAME")
    private String firstname;

    @NotNull
    @Column("ID")
    private Integer id;

...

}

[Timo Westkämper (timo-westkamper)]

Released in 1.9.4