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
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-
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
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