We have found an interesting behavior that has only cropped up since we
updated from OJB 1.0.2 to 1.0.3. We have an object mapping defined as
follows:
<class-descriptor class="com.dchoc.sphinx.entity.QuestionEntity"
table="QUESTIONS">
<field-descriptor id="1" name="id" column="ID" jdbc-type="INTEGER"
primarykey="true"
autoincrement="true" />
<field-descriptor id="2" name="batchId" column="BATCH_ID"
jdbc-type="INTEGER" />
<field-descriptor id="4" name="title" column="TITLE"
jdbc-type="VARCHAR" />
<field-descriptor id="5" name="text" column="TEXT" jdbc-type="VARCHAR" />
<reference-descriptor name="batch"
class-ref="com.dchoc.sphinx.entity.BatchEntity">
<foreignkey field-ref="batchId"/>
</reference-descriptor>
</class-descriptor>
First, using PersistenceBroker.store(obj), we create a question object in
the database that has a batch ID set, but whose batch member variable is
null. In this case, the row in the QUESTIONS table is created properly
with the appropriate BATCH_ID value. However, if we then update this same
question object using PersistenceBroker.store(obj,
ObjectModificationDefaultImpl.UPDATE), the batch ID in the object and the
database is updated to 0 - presumably because the batch reference in the
object was null (I should mention that the batch ID referenced in the
batch ID member variable does exist in the database). As mentioned, this
has only started happening since OJB 1.0.3. In 1.0.2, if the batch
reference was null, the batch ID was left alone. Presumably, the older
version did the more appropriate thing and left the member
variable/database value associated with the foriegnkey field-ref alone if
the reference-descriptor was null. Why does the more current version set
the value to 0 and save it to the database in this case? Is there some
reason it has to work this way? The old behavior seemed a lot more
friendly. With the new behavior, after creating the question, we have to
hit the database again to look it up via a persistence broker so that the
reference descriptor object will be filled in and our ID won't be reset to
0 if we do anymore updates on the question object.
Thanks,
Leigh
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
