Ticket #53 (closed: open)

Opened 12 years ago

Last modified 11 years ago

Errors during save may corrupt a database

Reported by: jeroens Owned by: administrator
Priority: high Milestone: Ecopath 6: build 6.0.7
Component: Database / Import Version:
Severity: feature Keywords:
Cc:

Description

If a database error occurs during an attempt to save a model or scenario, existing rows may be affected to a degree that they are no longer usable for loading. To prevent users from losing work, EwE must have some type of rollback mechanism.

Some research needs to be dedicated whether adodb.net can use proper SQLTransactions for performing rollbacks in case of save errors.

If transactions cannot be used, we may have to build a hokey solution that copies the current .MDB file to a safe location (at either regular intervals or right before any changes are to be made) so we have a way to revert to a working DB.

Change History

comment:1 Changed 12 years ago by jeroens

Implemented a basic transaction system. Needs further testing!

Note: See TracTickets for help on using tickets.