Forum:

JDBC and Relational Databases

getPrimaryKeys() method of DatabaseMetaData

Ranch Hand

Posts: 36

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

author & internet detective

Posts: 41093

848

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Jeanne Boyarsky

author & internet detective

Posts: 41093

848

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

JulianInactive KennedyInactive

Ranch Hand

Posts: 823

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Ranch Hand

Posts: 36

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Let's go to the waterfront with this tiny ad:

free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth

https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter