how to guarantee atomicity across two databases (the filesystem and your RDBMS)?
Posted
by Lock up
on Stack Overflow
See other posts from Stack Overflow
or by Lock up
Published on 2010-03-26T18:40:07Z
Indexed on
2010/03/26
18:43 UTC
Read the original article
Hit count: 130
database-design
i am working on a online file management project.In which we are storing references on the database(sql server) and files data on the on file system;.In which we are facing a problem of coordination between file system and database while we are uploading a file and also in case of deleting a file that first we create a reference in the data base or store files on file system;;the problem is that if create a reference in the database first and then storing a file on file system.bur while storing files on the file system any type of error occur.then reference for that file is created in the database but no file data on the file system;; please give me some solution how to deal with such situation;;i am badly in need of it;; and reason for that?
© Stack Overflow or respective owner