Just to correct a possible misunderstanding - iBATIS does not detect the dependancy on your delete. MySQL is doing it through a cascaded delete.
iBATIS is really just sending SQL to the database through JDBC - there's very little magic going on here.
iBATIS knows very little about your table s
Hi
Albert,
thanks a lot for the
answer. Indeed it was the reason of the problem. I added the following selectKey
to my mapping file and it works:
INSERT INTO instrument (internalNumber) VALUES
(#internalNumber#)
SELECT
last_insert_id()
I'm now facing
Reza,
I don't know if this is what is causing the problem, but I think there
might be a problem with your table definition for the option table.
instrument_id is supposed to reference the id in the instrument table,
but you have it set up as a auto_increment field. I would think
that you would
Title: multiple insert within a select tag
Hi all,
following scenario:
I'va an object Instrument. It references an another object option.
create table instrument (
id int not null auto_increment primary key,
internalNumber varchar(12) not null unique
);
c
