When having a JPA unique constraint on a field, such as:
{ { code}
@Table(name = "my_table", uniqueConstraints = {@UniqueConstraint(columnNames = {"my_field"})
{code } }
Hiberbate generates the following SQL statement:
{{create unique index <generated_name> on my_table(my_field)}}
For MySQL/MariaDB and PostgreSQL, such an index allows multiple null values if {{my_field}} is nullable. However, for JavaDB, this fails. To allow multiple null values, JavaDB requires a statement like the following:
{{alter table my_table add constraint <generated_name> unique(my_field)}}
This statement will allow multiple null values. |
|
