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?
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?
Joined: Feb 25, 2004
perfect Julian.... the problem is now solved. thanks for ur comments
subject: getPrimaryKeys() method of DatabaseMetaData