Hi Bret,
Are ID2 and ID1 a part of PK, or maybe an FK participating in a
relationship? Just a random question, since I can't tell right away what
is happening here...
Andrus
> I have an application that reads in a flat file and fetches/creates and
> updates the DB based on the information it finds. I am seeing strange
> updates statements during commit that are basically overwriting
> information with nulls.
>
> Basically, the scenario that I am seeing is that one of the objects can
> have 2 identifiers in addition to its key. This application only cares
> about ID1. ID2 is set by another process so if it is there, great; if
> not then don't worry about it.
>
> However, what I am seeing is that during commit, an update statement is
> being generated for most of the objects that sets ID1 to its value and
> ID2 to null, effectively overwriting the data that is present. I am a
> little confused on how this could happen since I am not setting ID2
> anywhere in the application.
>
> Any thoughts?
This archive was generated by hypermail 2.0.0 : Fri Jan 23 2004 - 00:04:39 EST