Hi,
We r developing enterprise solution that's why we need inconsistence database operations.My problem is related with the transaction which are uncompleted.Suppose I have three networks(N1,N2,N3) and having separate databases for each network.A user is logging from N1 and initiated a transaction for N2 database.At that time network fails and the N1 is out.The resources are locked due to transaction.If network is up then the table referenced in transaction is not reachable.No one can access those tables.What can we do to release these resources?I mean how can we rollback those transactions that were uncompleted due to network failure.
Thanx in advance
We r developing enterprise solution that's why we need inconsistence database operations.My problem is related with the transaction which are uncompleted.Suppose I have three networks(N1,N2,N3) and having separate databases for each network.A user is logging from N1 and initiated a transaction for N2 database.At that time network fails and the N1 is out.The resources are locked due to transaction.If network is up then the table referenced in transaction is not reachable.No one can access those tables.What can we do to release these resources?I mean how can we rollback those transactions that were uncompleted due to network failure.
Thanx in advance