RE: Very strange database behavior

2004-07-07 Thread Victor Pendleton
Are you saying that you are not receiving an Unique key violation when you enter in duplicate data or you are relying on a value being present? If you are using the later, do you have query caching turned on? -Original Message- From: Paul McNeil To: MySQL General Sent: 7/7/04 10:43 AM

RE: Very strange database behavior

2004-07-07 Thread Paul McNeil
' Subject: RE: Very strange database behavior Are you saying that you are not receiving an Unique key violation when you enter in duplicate data or you are relying on a value being present? If you are using the later, do you have query caching turned on? -Original Message- From: Paul McNeil

Re: Very strange database behavior

2004-07-07 Thread Bill Allaire
Paul, Has this class worked properly in the past? Have you tried executing the queries your class executes manually via the mysql client or a similar application removing your Java code from the equation? Have you run 'check table' if the table is either MyISAM or InnoDB? On Jul 7, 2004, at