Re: foreign key error, but only in jdbc.

[Mark Matthews]

Carl,

Running the stored procedure from workbench, even in quick succession is nowhere near the same behavior as calling it from multiple threads. Do you bracket the stored procedure with a transaction, or is it in autocommit mode? Stored procedures do not *imply* a transaction, they can either particpate in one, or start one themselves, although procedures that start their own transactions are usually not a good idea with more than simplistic programs, as MySQL does not support nested transactions.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html