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. |
|
