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 1

RE: Very strange database behavior

2004-07-07 Thread Paul McNeil
7;MySQL General ' 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-

RE: Very strange database behavior

2004-07-07 Thread Victor Pendleton
Subject: Very strange database behavior Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is set

Very strange database behavior

2004-07-07 Thread Paul McNeil
Good morning to all. I have a very strange problem in my database and am trying to track down whether it is a JAVA problem or a mySQL problem. I have a table that is supposed to accept only unique data, however, at this time, the PK for that information is set to the auto incrementing ID field. T