2011/3/31 鲍少明 <[email protected]>: > Thanks for Myrna's answer. But I am asking another function. Currently, I am > using Derby in the memory mode. > I need to know the table name list which has data changes during a > transaction. So I can export them into csv. > But there is not any information inside derby to tell me this update > history. So do I need to manually record the > table names which has really changed during a transaction? > > Thanks, > Clark > > 在 2011年3月18日 上午8:49，Myrna van Lunteren <[email protected]>写道： >> >> 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 > >
I saw your reply. I don't know the answer to your question. Perhaps someone else will speak up. Myrna
