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.

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.....