Subject | TransactionID from Transaction and Transaction Id from Record |
---|---|
Author | Danny Garcia Hernandez |
Post date | 2007-06-06T16:04:32Z |
Hi, i have used buffer comparison to implement optimistic blocking. When
my component call post with update transaction, the component read
inside other transaction the same record on the table, reading this
record with a buffer and check it with the oldbuffer looking for
diferences between buffers data. If some field have changed then i show
a message to ask post confirmation.
I think that buffer comparison is not the best option (what happen with
blob comparison?), but is the only that i have right now.
BTW, i´m looking for other solutions. For example. Make comparison
between transaction ids, one the transaction id asociated with the
update transaction and the other the transaction id asociated with the
newest record version on the database. If transaction ids are diferents
mean that other transaction have changed the record before me and i have
to show the message to ask port confirmation. I´t is posible?
Thank in advanced
Danny
my component call post with update transaction, the component read
inside other transaction the same record on the table, reading this
record with a buffer and check it with the oldbuffer looking for
diferences between buffers data. If some field have changed then i show
a message to ask post confirmation.
I think that buffer comparison is not the best option (what happen with
blob comparison?), but is the only that i have right now.
BTW, i´m looking for other solutions. For example. Make comparison
between transaction ids, one the transaction id asociated with the
update transaction and the other the transaction id asociated with the
newest record version on the database. If transaction ids are diferents
mean that other transaction have changed the record before me and i have
to show the message to ask port confirmation. I´t is posible?
Thank in advanced
Danny