2011/3/17 鲍少明 <[email protected]>: > I have checked the system tables derby using. I don't find any information > table to track the modify time of the tables. So does it mean I need to > write some code to manually track it. And if it's roll-backed, I need to > clean it up? > > 2011/3/14 鲍少明 <[email protected]> >> >> Hello group, >> Is there any easy way to track the tables which have been >> updated/deleted/inserted in one transaction? >> I know that I can add some code in my db operation code to track the >> status. >> But if I need to track some cascade delete or procedure call, I will need >> to write some ugly code to track them. >> >> Is there any easy way to get this done? Any suggestion will be helpful. >> >> Thanks, >> Clark Bao >
Derby manages all deletes/inserts/updates during a transaction, including adding of tables...If something fails in the middle, the entire transaction should get rolled back. Have you found a situation where this didn't work as you expected? Perhaps you need to look at your transaction logic... Perhaps I'm misunderstanding the situation. Maybe all you want is to compare the contents of SYS.SYSTABLES for your schema before and after the transaction? Perhaps you can find more of what you're looking for using the XPLAIN functionality that was introduced in 10.6; see the Reference Guide (http://db.apache.org/derby/docs/10.6/ref/ref-single.html) and/or tuning guide (http://db.apache.org/derby/docs/10.6/tuning/tuning-single.html). HTH, Myrna
