getPrimaryKeys() method of DatabaseMetaData

[sandeep kulkarni]

I'm facing very strange problem.
when I use the method getPrimaryKeys() for getting the list of primary keys of table.It is returing each value twice.(if there is only one key,it is returing the same key twice).
can anybody tell what might be the reason?

[Jeanne Boyarsky]

Sandeep,
I have no clue, but could you post the database and driver you are using? That might spark an idea for somebody.

[Jeanne Boyarsky]

Also, does it do that for all tables or just one?

[Julian Kennedy]

Sandeep,

Are you specifying anything for the schema and/or catalog parameters? It seems to me that if you have two schemas in your DB that contain the same table and PK, then a call to getPrimaryKeys() with an empty or null schema parameter would give you the same information twice.

Does that help shed any light on it?

Jules

[sandeep kulkarni]

perfect Julian....
the problem is now solved.
thanks for ur comments