Hey guys,

I've just started to play with MySQL, and am trying to get something I wrote to talk to it, but I'm having problems getting foreign key information out of the database. Here is a snippet of code :

Driver driver = (Driver) Class.forName("com.mysql.jdbc.Driver").newInstance(); String url = "jdbc:mysql://127.0.0.1/test?user=foo&password=foo"; Connection con = DriverManager.getConnection(url); DatabaseMetaData meta = con.getMetaData ();

ResultSet primRS = meta.getPrimaryKeys (null, null, "Address"); while (primRS.next ()) System.out.println("column key == " + primRS.getString("COLUMN_NAME"));

ResultSet metaRS = meta.getImportedKeys(null, null, "Address"); while (metaRS.next()) System.out.println("foreign key == " + metaRS.getString("FK_NAME"));

The Tables are created like so :

CREATE TABLE Student ( Student_ID INT PRIMARY KEY, First_Name varchar(50), Last_Name varchar(50), UNIQUE (First_Name, Last_Name) );

CREATE TABLE Address ( First_Name varchar(50), Last_Name varchar(50), Address varchar(50), PRIMARY KEY (First_Name, Last_Name), FOREIGN KEY (First_Name, Last_Name) REFERENCES student (First_Name, Last_Name) );

The problem is that when I do meta.getImportedKeys(...), it returns an empty set. I've tried the same thing, but using a single column foreign key, but that still returns an empty set.....

Mof.