Refactor your table and move the unique stuff to an extra table and
enforce the DB-level uniqueness there?
Hmm... can be done of course, but at the first look it seems to me a
bit on the complex side: to re-factor the database and to write the
Java glue to make two different attributes look like just one with
two different kinds of values and so forth just to make one save-and-
test atomical? Moreover, I am not designing: the application already
runs; making some values in one column--which already exists--unique
is a change request.
Anyway thanks a lot: I haven't considered this possibility. Perhaps
it will prove to be the best one.
---
Ondra Čada
OCSoftware: email@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc