[EMAIL PROTECTED] wrote:
Frank Schröder <[EMAIL PROTECTED]> wrote on 05/31/2005 03:18:11 AM:
Hello,
I have an InnoDB table running on MySQL 4.1.11 with multiple FK
constraints. I'm accessing it via JDBC from Java.
When an FK constraint fails with error 1216 I need to know which of the
constraints failed.
SHOW INNODB STATUS returns the following output
...
CONSTRAINT `u_registration_ibfk_1` FOREIGN KEY (`DEVICE_ID`)
REFERENCES `u_device` (`DEVICE_ID`)
...
Is there a way of getting to the name of the last failed FK constraint
without using SHOW INNODB STATUS? What I need is the
'u_registration_ibfk_1' from the above example.
Any help is highly appreciated
--
Frank
Have you looked at the results of SHOW INNODB STATUS; ?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Yes, as you can see from my original post I'm actually trying to figure
out how to do this *without* SHOW INNODB STATUS as this reports the
last FK failure for the entire engine and not just my session - at least
that's how I interpret the documentation.
The thing that's really a headscratcher for me is why its possible for
me to set a name for a constraint if it isn't displayed in an error and
I can't get to it. It's useless. I have a hard time believing that so I
figure that I just haven't figured out how to get to it. I just didn't
think that it was sooooo hard.
--
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
