x*****n 发帖数: 98 | 1 problem: When I update some rows, how can I get the rows that have just been
updated, genericly?
Solution: 1.I've meant to use the JDBC 2.0's new feasures: updatable Resultset.
Unfortunatly the underlying JDBC DB2 driver didn't support it. Then I have to
write a parser to analyze the value expression. That's use select to get the
rows that will be updated. Then compute the new values according the expression
and update the corresponding columns.
The original purpose of it is: build a layer above | j***w 发帖数: 1 | 2 I am not familiar with DB2. But the easiest ways I could think are
1. using rollback a transaction to undo update(s)
2. using triggers to store updated values and old values
actually, I have no idea why you need to redo update(s).
Resultset.
to
expression
any
value
the
【在 x*****n 的大作中提到】 : problem: When I update some rows, how can I get the rows that have just been : updated, genericly? : Solution: 1.I've meant to use the JDBC 2.0's new feasures: updatable Resultset. : Unfortunatly the underlying JDBC DB2 driver didn't support it. Then I have to : write a parser to analyze the value expression. That's use select to get the : rows that will be updated. Then compute the new values according the expression : and update the corresponding columns. : The original purpose of it is: build a layer above
|
|