I have the wierdest problem an I am at a loss.
The insert function, as for the code underneath, partially works. I say
partially, as I can see that the primary key is actually incremented. But
sometimes the new record fails to show in the table, and when it does
other records are removed. The behaviour is random to the point that I
cannot give a better description. My first thought was that this might
have been related to the use of INNODB tables and the cascade delete
option. But if I insert the record directly from the mysql consolle then
everything works fine ..
What is going on ?
Here is my java code:
----------------------------
Statement st = connection.createStatement();
String sql = "INSERT INTO bb_replies
VALUES('"+userName+"','"+email+"','"+subject+"','"+content+"','"+dateString+"',"+bbclass+","+rootIndex+","+rootIndex+","+replyIndex+",NULL)";
try {
st.executeUpdate(sql);
}catch(SQLException se){
out.println( se);
}
---------------------------------------------------
here is my mysql INNODB tables
---------------------------------------------------
create table institutions (
institution char(30) NOT NULL,
i_key INT NOT NULL auto_increment,
primary key(i_key)
) TYPE=INNODB;
create table classes (
i_key INT,
owner_key INT,
classname char(20) NOT NULL,
auditorium_schedule text,
c_key INT NOT NULL auto_increment,
primary key (c_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES institutions (i_key)
ON DELETE CASCADE
) TYPE=INNODB;
create table bboard (
userName char(40),
email char(20) NOT NULL,
subject text NOT NULL,
content text NOT NULL,
fontType char(20) NOT NULL,
pinColor char(10) NOT NULL,
date char(10) NOT NULL,
c_key INT,
owner_key INT,
m_key INT NOT NULL auto_increment,
primary key(m_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES classes (c_key)
ON DELETE CASCADE
) TYPE=INNODB;
create table bb_replies (
userName char(40),
email char(20) NOT NULL,
subject text NOT NULL,
content text NOT NULL,
date char(10) NOT NULL,
class INT NOT NULL,
m_key INT NOT NULL,
owner_key INT NOT NULL,
dependency_key INT NOT NULL,
r_key INT NOT NULL auto_increment,
primary key(r_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES bboard (m_key)
ON DELETE CASCADE
) TYPE=INNODB;
---------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
