DatabaseMetaData.getImportedKeys problem
Posted by: roger
Date: March 31, 2005 03:03PM

We have a strange problem reported from one of our users using DbVisualizer.

1) The problem appears when running the MySQL DB on Mac OS X. All table names in the actual database starts with an uppercase letter i.e Brand, Client, etc. If we now execute DatabaseMetaData.getImportedKeys() then it gives the following result with all letters in the the PKTABLE_NAME column in lowercase while the FKTABLE_NAME shows the correct spelling.

PKTABLE_NAME
-------------------
account
account_notes
analytic
brand
client

FKTABLE_NAME
-------------------
Account
Account_Notes
Analytic
Brand
Client

2) Running the very same MySQL DB on a Linux box using the same JDBC version gives the following correct result:

PKTABLE_NAME
-------------------
Account
Account_Notes
Analytic
Brand
Client

FKTABLE_NAME
-------------------
Account
Account_Notes
Analytic
Brand
Client

Why this deviation?

Roger Bjarevall
Minq Software

Options: ReplyQuote


Subject
Written By
Posted
DatabaseMetaData.getImportedKeys problem
March 31, 2005 03:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.