the derby engine and I need to know exactly the point in the commit procedure where data is actually written or updates on disk.
I don't think it works that way.
The *log* is written to disk at commit time, but the *data* need not be. The data is written to buffered pages in memory, and pages are written to disk asynchronously. The general term for this is "write ahead logging". thanks, bryan