I'm trying to dynamically get the parent table names and foreign key column names of a database. However, when I try to use getExportedKeys() it returns an empty ResultSet.
I have read on another thread that this may be a known bug. The thread recommends upgrading the mysql connector to the latest version. I have upgraded to the latest alpha mysql-connector-java-6.0-nightly-20101119-bin.jar for Mac OS X but the issue still remains.
http://www.tonews.com/thread/1395546/mailing/database/mysqljava/databasemetadata_getexportedkeys.html
I have created a simple table using a .sql script. I am using MySQL.
I am using the following to extract the results from the database.
I am able to retrieve primary keys calling getPrimaryKeys() just fine. However, calling getExportedKeys() always returns a ResultSet that is empty. What might I be doing incorrectly? Thank you for reading this!