Re: [JDBC] determine if a column is UNIQUE using metadata

From: Kris Jurka <books(at)ejurka.com>
Date: Sun Jan 20 2008 - 10:15:19 EST

On Sat, 19 Jan 2008, Peter Michaux wrote:

> I've been trying to determine if a column is UNIQUE. I've been trying
> to use the following
>
> connection.getMetaData().getIndexInfo(null, "", "comment", false, true);
>
> but it always says that the columns are not unique.
>
> Am I on the right track with the above technique or should I be trying
> to do something totally different?
>

The driver's test suite includes a test for ensuring NON_UNIQUE is returned correctly and it works for me. Could you post a complete example (including table/index creation) of it failing.

Kris Jurka

---------------------------(end of broadcast)---------------------------

TIP 5: don't forget to increase your free space map settings Received on Sun Jan 20 10:17:24 2008