is there a way to mix an unique column with null values. So that i have an column where only unique values are allowed with the exception of multiple null values.
Yes. Since Derby 10.4, that is the way that Derby's table-level UNIQUE constraints have worked. See: http://db.apache.org/derby/docs/10.8/ref/rrefsqlj13590.html thanks, bryan
