Need Quick Help !! Production Issue
Somendra Paul <som_paul <at> yahoo.com>
2008-06-29 05:50:00 GMT
These are the following java objects that we store:
Wip --> Wip Process(related table of Wip) -> Wip Qty (related table of Wip)
Lot --> Lot Qty(related table of Lot) -> Lot Process Location(related table of Lot)
The way our code works is this Wip,Lot,Shipment data are kept in csv files, they are then converted to thier
respective java objects and then
persisted to the DB, one by one.
Suppose a file can contain 100 Lot, 100 Wip, and 100 Shipment and they can be interlaced, what i mean is that
Lot,Wip and Shipment can come in
any sequence, and not that first 100 Lot and then 100 Wip and then Shipment.
Suppose our file has Lot, Shipment and then Wip:
Our setting in repository-database.xml is batch-mode is true,and autoComit is 2 and when the three
objects are persisted, we find that
sometimes and that is quite rare, that the some of the objects are actually not persisted in DB, though there
is no exception in logs,
we are using OJB1.0.4.
Current Code Behaviour of Code: -->
The way our code works is we get the transaction from the PB broker, and then start the transaction and then
insert the Lot object,afterthat they
will persist the Lot Qty and Lot Process Location objects which are information related to lot, by setting
the batch mode to true and then calling broker.
store(pc) for each LotQty or Lot Process Location and then call batchUpdate (intention being that the