-----Original Message----- From: Allen Weeks [mailto:alle...@starband.net] Sent: Thursday, August 07, 2003 4:52 PM To: Java List Subject: Strange Update behavior

Hello All,

I have a java application that accesses my database using MySQL Connector/J 3.0.7 Stable and server version 3.23.38 (win2k). The strange behavior occurs when I send an update query to the database from one area in the application, then send another update query to the same table from a different area in the application.

The behavior is that the first update query sets/updates 2 fields in a record and the program goes about it's merry way. The next update query accessing the same record is written to update of almost all the other fields in the record except the 2 updated before. The strange thing that happens is that when the general update occurs, the 2 original fields are set to null with any coding directing that to happen.

Field1 Field2 value initial null null after 1st query John Public after 2nd query null null

Have any of you seen this behavior before?

Thanks in advance for any help.